Creating Calculation using Selected Value function

[Nino1]

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 

[anilkapkoti · Accepted solution]

Use the below dax it will work

VAR SelectedValue = SELECTEDVALUE(CurrencyAdjustment)

RETURN
SWITCH(
SelectedValue,
"Yes", SUM('Portfolio'[AdjustedCurrencyValue]),
"No", SUM('Portfolio'[NominalValue])
)

[anilkapkoti · Accepted solution]

Use the below dax it will work

VAR SelectedValue = SELECTEDVALUE(CurrencyAdjustment)

RETURN
SWITCH(
SelectedValue,
"Yes", SUM('Portfolio'[AdjustedCurrencyValue]),
"No", SUM('Portfolio'[NominalValue])
)

[Nino1 · Accepted solution]

Thank you very much, it works !