Forum Discussion
Helper IHighest value per cluster
Hi robertosangi ,
According to your screenshot, I think your table should look like as below.
I think you want to show values in red box.
I suggest you to create a rank measure and use it as a filter in visual level filter.
RANK = VAR _RANK = RANKX ( ALLEXCEPT ( 'Table', 'Table'[Unite], 'Table'[Blue Team] ), CALCULATE ( SUM ( 'Table'[IGB_NoLoc] ) ), , DESC, DENSE ) RETURN _RANKResult is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IHi Anonymous,
Sure, I'll try to explain better
As you can see this is the AS IS situation. I want, per each red category, the highest IGB_NoLoc value. So, in this case for PALERMO EST only the first and the third value. In PALERMO OVEST only the first.
It is clear? I'll try to explain better if not.
Thanks
Hi robertosangi ,
According to your screenshot, I think your table should look like as below.
I think you want to show values in red box.
I suggest you to create a rank measure and use it as a filter in visual level filter.
RANK =
VAR _RANK =
RANKX (
ALLEXCEPT ( 'Table', 'Table'[Unite], 'Table'[Blue Team] ),
CALCULATE ( SUM ( 'Table'[IGB_NoLoc] ) ),
,
DESC,
DENSE
)
RETURN
_RANKResult is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.