How to add Max to a Measure

[jdelekta]

Hello,

I have created a measure that calculates the date difference between different work item states. I am trying to answer the question of how long it takes to complete work after development is started but before its released to production. Which is working. However - I'd like to get the MAX of all the values so I can plot it on percentiles. The calculation is below with the names of the tables removed. I have a couple of questions:

1) Is there a way to wrap this measure with a MAX?

2) When I remove "Work Item ID" from the view the values don't display

Thank you.

[PawelWrona]

The value is not displayed when you take away "Work Item ID", as in RETURN statement of your measure you ask to return a value only when there is a single value of "Work Item ID". When you take it away, you make attepmt to display a measure without the context of "Work Item ID" (on total level), therefore, there is no longer single value available of "Work Item ID" and your measure returns BLANK().

But don't remove HASONEVALUE part from your calculation in order to have any result calculated as it won't be correct. Your aggregation variables that calculate MIN values for different states may come from different "Work Items ID", and you will not compare proper values.

In order to get proper MAX of all values available on "Work Item ID" level, Greg already provided good solution.

[Greg_Deckler · Accepted solution]

@jdelekta This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.