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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

So in this case I think I would need a preprocessed table to filter from that has already these Bar-plot like values cummulated...

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

Hi Anonymous ,

If you want to take the slicer into consideration, replace ALL with ALLSELECTED. Or if you want to keep the filter with a specific column. use ALLEXCEPT function.

 

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.