help with a dynamic segment to be created

[m92240]

Hello,

I need your help with a measure I have created which calculate a specific rate.

I would like to have a dynamic filter for which If I click (top left) on [0-20], I only have in the tab values below 20%. Same for [20-50]... 

I could not group the data due to the fact that I have a DAX measure...

Could you please help me ?

[Icey · Accepted solution]

Hi @m92240 ,

Try to create a measure like below and replace your measure with it in the Matrix visual.

Measure =
SWITCH (
    SELECTEDVALUE ( 'YourTable'[Column1] ),
    "[0-20]", IF ( [YourMeasure] < 0.2, [YourMeasure] ),
    "[20-50]", IF ( [YourMeasure] < 0.5, [YourMeasure] ),
    [YourMeasure]
)

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[Portrek]

Hi M92240

You can create a custon collum in your table with conditional related a value to yours paramters the filter, like:

custoncolumn = IF(tABLE1[COLUMN]<=20,"A",IF(tABLE1[COLUMN]<=60,"B","C"))

After, you put that collum in the filter.

See you.