Bundling Measures Together

Philip Seamark shows how to bundle measures together in Power BI so they all appear at the top of the Fields section:

I’m going to share in this blog a technique I’ve found useful in Power BI for collecting measures together in once place AND placing them at the top of the field list.

The good news is, calculated measures do not have to exist on the table that stores the underlying data specific to that measure.  Measures can be placed on any table in the model and they will still work as expected.  This may not be immediately obvious but it’s handy to know.

So far, I’ve kept measures on their logical best-fit tables, but Philip’s hint looks quite useful once the set of measures grows, or if there are a number of cross-table measures.

Related Posts

Heat Streams Custom Visual

Devin Knight continues his Power BI custom visuals series: In this module you will learn how to use the Heat Streams Custom Visual.  The Heat Streams visual allows you to visualize and compare a categorical value over time. This looks pretty interesting when comparing a number of elements over time—more elements than a line chart […]

Read More

Spelunking In The SSRS REST API

Chris Webb uses Power BI to look at the new SQL Server Reporting Services 2017 REST-based API: And the online documentation for the API is here: https://app.swaggerhub.com/apis/microsoft-rs/SSRS/2.0 Interestingly, the new API seems to be OData compliant – which means you can browse it in Power BI/Get&Transform/Power Query and build your own reports from it. For example in […]

Read More

Categories

June 2017
MTWTFSS
« May Jul »
 1234
567891011
12131415161718
19202122232425
2627282930