Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Get Max Bin Value via Measure based on Filter

Hi All,   I struggle a lot with the following. I can visualize a bar plot based on one binned table column and a measure that distributes its values over the bins. This looks as follows. Now I woul...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi v-yanjiang-msft ,

    I came up with a good solution for my problem:

     

    MAXX(FILTER(SUMMARIZE(data, data[Values (bins)], "Measure Bins", data[Values (Measure)]), [Measure Bins] >= 13),[Values (bins)])

     The issue was that I needed to group the Measure Values to the binned Values first...

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi Anonymous ,

As measures are calculated based on context, usually we should use ALL function when filter table.

Modify the formula to:

MAXX ( FILTER ( ALL ( data ), data[Values (Measure)] >= 13 ), [Values (bins)] )

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.