topic Re: Creating Calculation using Selected Value function in DAX Commands and Tips

Creating Calculation using Selected Value function

Nino1 — Tue, 08 Aug 2023 13:36:13 GMT

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

Re: Creating Calculation using Selected Value function

Anonymous — Tue, 08 Aug 2023 14:52:22 GMT

Use the below dax it will work

VAR SelectedValue = SELECTEDVALUE(CurrencyAdjustment)

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

Re: Creating Calculation using Selected Value function

Nino1 — Tue, 08 Aug 2023 15:39:36 GMT

Thank you very much, it works !