Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

help with a dynamic segment to be created

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 ?

 

Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    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.

2 Replies

  • Portrek's avatar
    Portrek
    Icon for Resolver III rankResolver III
    5 years ago

    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.

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    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.