Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I am stuck on a verge of closure, please help.
I have a table where i have create 2 column one financials in Euros and another one Financials in Dollar.
I need to display the values as per filter Selection of currency - Euro/USD
I tried switch function, it did not work for multiple values hence i thought of creating another another column with IF Statement and take the output for my work but i am getting the above error, Please guide it is urgent. I need the output in column to create waterfall chart of financials
Solved! Go to Solution.
@Anonymous
You are trying to create a column with a slicer value. Only a measure can use Slicer Value.
new mesure =
if([selected Value] ="EUR",max(Waterfall[Result]),max(Waterfall[Result2]))
@Anonymous
You are trying to create a column with a slicer value. Only a measure can use Slicer Value.
new mesure =
if([selected Value] ="EUR",max(Waterfall[Result]),max(Waterfall[Result2]))
hi @Anonymous
try SELECTEDVALUE():
= if(selectedvalue([selected currency]) = "eur", [Result], [Result2])
User | Count |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
100 | |
91 | |
83 | |
61 |