Forum Discussion
Labour Turnover Rate
Anonymous 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.
If that doesn't help, probably need sample data as text.
Hi Greg, link to file below. Same data numbers, just anonymised.
I think having read your blog article that this is along the lines of what I am needing but have struggled to apply the logic to my data.
As mentioned previously, I am stuck with creating an additional measure that cumulatively sums the measure used to create the Active Staff at Snapshot matrix values, leading to something like this......
I would then look to divide each value by FINMONTHNUMBER to obtain an average FYTD. Thanks in advance.