cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TonyR
Frequent Visitor

Measures in a separate table

Hi,

I noticed in one of the example dashboards, Portfolio Slicer,  that all the measures were stored in a seperate 'table'. It also has a dfferent icon to normal tables.

 

In the screenshop below it's called Report. Does any now how to create the Report entity itself 

http://screencast.com/t/nqAMUpTvF

 

Also, any thoughts on this methodology?  

 

Thx

tony

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

Re: Measures in a separate table

This is not an uncommon practice. Not sure about the icon, but you could create a Blank query, not add any steps and save it. Then, add measures to that "table". Measures are table inspecific, so they can technically live anywhere.


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

8 REPLIES 8
Super User IV
Super User IV

Re: Measures in a separate table

This is not an uncommon practice. Not sure about the icon, but you could create a Blank query, not add any steps and save it. Then, add measures to that "table". Measures are table inspecific, so they can technically live anywhere.


---------------------------------------

Not the Power BI thought police...

I have NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

Super User IV
Super User IV

Re: Measures in a separate table

Hi @TonyR the reason that it has a different icon, is that if you only keep your Calculated Measures as visible, and hide all other columns (including your Calculated Columns), when you close and then open your Power BI Desktop Model the icon will then change to show you that the table only has Measures.

 

This is sometimes a good way to design your Power BI Model, as @Greg_Deckler suggested. In creating your model in this manner, the end users know where to find any measures that they require. And the rest of the tables are available to slice and dice their data.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog
Steve_Wheeler Solution Sage
Solution Sage

Re: Measures in a separate table

That model seems to have been inherited (imported?) from the Excel version of that Portfolio Slicer - the Report table is a single row/single column table, effectively built via "Enter Data" feature.

 

There was some discussion recently on the topic in this forum thread: Re: How to keep the model tidy?

 

And it's also touched on in this Idea: Grouping Fields into dimensions and measure

 

And there's discussion of accessing the PBI data model here: How to hack yourself in Power BI (and Power Pivot?)

 

Historically, I think the recommended practice in SSAS etc. was to group Measures with Fact tables on granularity, but I wonder if that's still relevant for Power BI?  I'm not sure if it scales, and it breaks the drill-through PivotTable feature in Excel to have measures separate from the table, but it could be simpler for business users to navigate with all measures in one place, some Measures use mutliple tables anyway and, if you re-create a table by changing the query, it can trash any measures you've added to it!

 

In the webinar How to Design Visually Stunning Reports, Miguel Myers makes a point of surfacing Measure descriptions as Tooltip helpers on his reports.  And Excel etc. let you record a Measure description, wheras Power BI currently does not.

 

Until a baked-in solution for documenting measures is released, I can see a case for a "Measures" or "Report" table to hold the Description of each measure, as well as the measures themselves.  If it scales...

 

 

TonyR
Frequent Visitor

Re: Measures in a separate table

Thank you Steve for the detail response. Much appreciciated. I'll check out the links

TonyR
Frequent Visitor

Re: Measures in a separate table

Thx Guavaq

Highlighted
TonyR
Frequent Visitor

Re: Measures in a separate table

Thx @Greg_Deckler . Appreciate the response .

russellclaude
Frequent Visitor

Re: Measures in a separate table

Create a new table....
 
_Measures = {BLANK()}
Super User IV
Super User IV

Re: Measures in a separate table

Hi there

In the new modelling view, you are able to assign measures to a folder.

https://www.youtube.com/watch?v=VlcHMRiKLT8




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors