Dynamic measure based on the selected value of the slicer

[mjmjn2611]

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)

[Anonymous · Accepted solution]

Hi @mjmjn2611 ,

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

ForSlicer = VALUES('Table'[Product])

Then please try this:

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.

[amitchandak]

@mjmjn2611 , Try a measure

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

[mjmjn2611]

@amitchandak 

Thank you for your solution. 

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.