Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Everyone,
It's not been a long time I started using Power BI and need your help.
I have two measures: "sum of portfolio with nominal values" and "sum of portfolio with adjusted currency value". Also, I have Slicer filter called Currency adjustment that has 2 values: "Yes" and "No" and I want to create vizualization so that if I select filter and choose "Yes" , "sum of portfolio with adjusted currency value" should be shown on vizualization and if I select filter and choose "No", "sum of portfolio with nominal values" should be shown on vizualization.
I tried to create a measure using selectedvalue function but could not deal with it. Could you please help how can I solve this problem?
Thank you
Solved! Go to Solution.
Use the below dax it will work
VAR SelectedValue = SELECTEDVALUE(CurrencyAdjustment)
RETURN
SWITCH(
SelectedValue,
"Yes", SUM('Portfolio'[AdjustedCurrencyValue]),
"No", SUM('Portfolio'[NominalValue])
)
Use the below dax it will work
VAR SelectedValue = SELECTEDVALUE(CurrencyAdjustment)
RETURN
SWITCH(
SelectedValue,
"Yes", SUM('Portfolio'[AdjustedCurrencyValue]),
"No", SUM('Portfolio'[NominalValue])
)
Thank you very much, it works !
User | Count |
---|---|
56 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |