Skip to main content

Power BI

New

Measure Management

Vote (46) Share
Keith Deveney's profile image

Keith Deveney on 16 Nov 2017 00:29:24

I would like a way to better organize the measures and calculated columns that are created. Currently measures and calculated columns are placed amongst the table columns alphabetically. In order to organize the measures, I need to build a standard naming convention to keep them together. This is even more important as the data models become quite complex with many measures. I would like a way of storing measures in folders within the table so I can flexibility on how they are categorized and their purpose.

Comments (4)
Keith Deveney's profile image Profile Picture

411a60ba 5540-46c4-9efc-ef56c25ae52b on 06 Jul 2020 00:02:30

RE: Measure Management

I love DaveG's mockup

Keith Deveney's profile image Profile Picture

2826746b 8215-4a3d-9ec2-66c1eaa6166e on 05 Jul 2020 23:14:20

RE: Measure Management

There's a trick you can use to do measure groups:

http://radacad.com/how-to-better-organise-your-power-bi-measures

However would be better if there was a button to create these as this is a very well hidden feature.

Keith Deveney's profile image Profile Picture

aed038dd e308-4c4a-8319-f54f0cd7e7a7 on 05 Jul 2020 23:11:08

RE: Measure Management

This older idea has 500+ votes:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16783000-measure-dependency-view-similar-to-the-query-depe

Keith Deveney's profile image Profile Picture

1e753da8 650d-4de6-8d63-8abe5ec68a75 on 05 Jul 2020 23:08:59

RE: Measure Management

I've prepared a mockup for this as well as a DAX Editor. Let me know what you think.

Mockup: https://i.imgur.com/z6TBOQb.png?1