Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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
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
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
96 | |
89 | |
73 | |
61 | |
58 |