Slice value is not working with IF condition in a measure

[Amar-Agnihotri]

Hello All, I have a slicer and taking that value into a measure to use further in calculating another measure. Example - Slicer will have USD, GBP, EUR and trying getting sales*currenyrate based slicer selection, but som how it is not working me as expected. Measure - if(slicer='"EUR",sales*currencyrate,0), I am getting 0 as output. If i remove IF condition of slicer check, it is giving me some result instead of 0, why this happens, how can i achieve the expected result.

[Anonymous]

Hi @Amar-Agnihotri ,

Is the formula looks like below?

IF(selectedvalue(slicer)= "EUR", ... , ...)

Can you show some sample data and the formula you are using to us?

Best Regards,

Jay 

[goncalogeraldes]

Could you provide your DAX formula? The solution may be something like:

Measure =
var selected_value = SELECTEDVALUE(Column that is used in the filter)

return
if( selected_value = "EUR",
sales*currencyrate,
0)

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes