Forum Discussion

Lewdis's avatar
Lewdis
Frequent Visitor
2 years ago
Solved

Local or USD selection

I am currently transfering from Tableau to Power BI and struggle a bit.   I am currently using a parameter with a single value picklist that has the option Local or USD.    Then each measure has ...
Need Help
  • Lewdis's avatar
    Lewdis
    2 years ago

    I used the following formula linking to the parameter

     

    Sales Dynamic =
    SWITCH(
        SELECTEDVALUE(prmSalesCurrency[prmSalesCurrency Fields]),
        "'Dataset Measures'[Sales]",sum('Dataset'[Sales]),
        "'Dataset Measures'[Sales USD]",sum('Dataset'[Sales_USD])
    )
lbendlin's avatar
lbendlin
Super User
2 years ago

The Power BI equivalent is SWITCH  (nested IFs, basically) but you can also use Field Parameters (using the measures)  or Calculation Groups  (which requires an external tool called Tabular Editor).

 

Field Parameters would be my choice.

  • Lewdis's avatar
    Lewdis
    Frequent Visitor
    2 years ago

    Thanks for your help. I dont fylly get it yet. I have a dataset with Sales in local or USD. In that dataset i also have YTD sales and Budget. I want the parameter to cover all of those options.

     

    Also notice that when I try to use the parameter only for Sales it doesnt show as number. It shows as text.

     

    Thanks 

     

     

     

    • Lewdis's avatar
      Lewdis
      Frequent Visitor
      2 years ago

      I used the following formula linking to the parameter

       

      Sales Dynamic =
      SWITCH(
          SELECTEDVALUE(prmSalesCurrency[prmSalesCurrency Fields]),
          "'Dataset Measures'[Sales]",sum('Dataset'[Sales]),
          "'Dataset Measures'[Sales USD]",sum('Dataset'[Sales_USD])
      )