Forum Discussion
Solved
Narrative Measure Not Matching Correctly
Hi all, I have this table of values: You'll see that the highlighted value of 20 for the Function 'Executive Assistants' is the highest value in the table. I'm using the following metric to ...
Hi, garynorcrossmmc
You can try the following methods.
Measure = MAXX(ALL('Table'),[Employees - Receiving Special Bonus])Is this the result you expected?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, garynorcrossmmc
You can try the following methods.
Measure = MAXX(ALL('Table'),[Employees - Receiving Special Bonus])
Is this the result you expected?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, Anonymous! This appears to now be returning the correct calculation with a slight modification:
Colleagues (Receiving Special Bonus) - Top Function # (TOPN) =
MAXX(ALLSELECTED('OWG Comp Listing'[Function]),CALCULATE([Employees - Receiving Special Bonus],'OWG Comp Listing'[Year]=2024))+0