cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
m92240
Frequent Visitor

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 ?

 

Tx staffing.png

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
Icey
Community Support
Community Support

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.

View solution in original post

Portrek
Resolver II
Resolver II

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.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors