Forum Discussion
Creating Calculation using Selected Value function
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
- Anonymous3 years ago
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 !
2 Replies
- AnonymousNot applicable
Use the below dax it will work
VAR SelectedValue = SELECTEDVALUE(CurrencyAdjustment)
RETURN
SWITCH(
SelectedValue,
"Yes", SUM('Portfolio'[AdjustedCurrencyValue]),
"No", SUM('Portfolio'[NominalValue])
)- Nino1Frequent Visitor
Thank you very much, it works !