cancel
Showing results for
Did you mean:
Frequent Visitor

## Dynamic measure based on the selected value of the slicer

Hi,

I want to create a dynamic measure where when I choose the value from the slicer, the row that contains the data from slicer with have an updated formula, other will have another formula.

For example:

If I choose product A, then the sales for product A would be calculated as 100 + sum(Sales)

Other products 200 + sum(Sales)

1 ACCEPTED SOLUTION
Community Support

Hi @mjmjn2611 ,

To my knowledge, you need to create a new table for slicer:

``ForSlicer = VALUES('Table'[Product])``

``Result = IF( MAX('Table'[Product]) in ALLSELECTED(ForSlicer[Product]),100+SUM('Table'[Sales]), 200+SUM('Table'[Sales]))``

The final output is shown below:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 REPLIES 3
Community Support

Hi @mjmjn2611 ,

To my knowledge, you need to create a new table for slicer:

``ForSlicer = VALUES('Table'[Product])``

``Result = IF( MAX('Table'[Product]) in ALLSELECTED(ForSlicer[Product]),100+SUM('Table'[Sales]), 200+SUM('Table'[Sales]))``

The final output is shown below:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User IV

@mjmjn2611 , Try a measure

if(countx(filter(Table, Table[Product] = "Product A"),[Product]) >0 , 100 + sum(Sales) , 200 + sum(Sales) )

Proud to be a Super User!

Frequent Visitor

The name of the product is not constant, I get it from the slicer. I am using Selectedvalue(slicer) to get the value for the product name. It doesn't work.

Announcements

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.