Forum Discussion

robertosangi's avatar
robertosangi
Helper I
4 years ago
Solved

Highest value per cluster

Hi,    In my case I want to obtain the highest value (top 1) of a column divided per cluster. Here the example: Actually I filtered my column as per picture because is not possible to filt...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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
    _RANK

    Result 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.

robertosangi's avatar
robertosangi
Helper I
4 years ago

Hi Anonymous thanks for your reply. I want to filter only per the highest value if possibile. Not filtering per 10 value

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi robertosangi ,

 

I think my measure will show you the highest value in IGB_Noloc. If this still couldn't help you solve your problem, please show me a screenshot with the result you want, this will make me easier to find the solution.

 

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.

  • robertosangi's avatar
    robertosangi
    Helper I
    4 years ago

    Hi 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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
    _RANK

      Result 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.