Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
102 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |