Forum Discussion
ccolletti
Helper I
Helper IRolling Up Values from Sublevel to Calculate at Higher Levels in Matrix and/or Table Visual
Hi all, and thank you in advance for all your help! I'm working on a report for my company that I was able to get a value down at the store sublevel on if the store reached compliance marking it ...
Hi ccolletti ,
Since I don't know how your measure Compliance is calculated, I'm assuming Review Count greater than 10 is 1. So the final result is a little different, but the overall logic is the same.
You can create the measure.
MEASURE = VAR _count1 = COUNTX ( FILTER ( ALLSELECTED ( 'Table'[Store] ), [Compliance] = 1 ), [Compliance] ) VAR _count2 = CALCULATE ( COUNT ( 'Table'[Store] ), ALLSELECTED ( 'Table'[Store] ) ) RETURN DIVIDE ( _count1, _count2 )
Set it as a percentage.If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ccollettiHelper I
Helper IAnonymous , yes this worked! Thank you so much for your help!