Forum Discussion

Nino1's avatar
Nino1
Frequent Visitor
3 years ago
Solved

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 

  • Anonymous's avatar
    Anonymous
    3 years ago

    Use the below dax it will work

    VAR SelectedValue = SELECTEDVALUE(CurrencyAdjustment)

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Use the below dax it will work

    VAR SelectedValue = SELECTEDVALUE(CurrencyAdjustment)

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

    • Nino1's avatar
      Nino1
      Frequent Visitor

      Thank you very much, it works !