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 achive the expected result.

[v-henryk-mstf · Accepted solution]

Hi @Amar-Agnihotri ,

According to your description, the error may be caused by the inconsistency between the format in the slicer field and the format in the judgment condition. I did a test, the reference is as follows:

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[Samarth_18]

Hi @Amar-Agnihotri ,

Can you check if your column which you are using contains blank space before or after your data or you can directly put trim when you taking slicer value in the variable like below:-

measure = 
var _slicer_value = TRIM(SELECTEDVALUE('Table'[Coulmn]))

Thank you,

Samarth