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

Hi v-yanjiang-msft,

 

thank you for the quick reply. Unfortunately, the table that I am working with already has some filters applied. In order for this to work, I think that I cannot use ALL, since I do not want to lose the filters.

 

 

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.