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])
    )
Lewdis's avatar
Lewdis
Frequent Visitor
2 years ago

So its not possible to use the same way to use the same setup as in my file and make it possible to switch between the Local or USD fields?

 

Case [Currency Local/USD]

when "Local" then [Sales]

when "USD" then [Sales_USD]

End

lbendlin's avatar
lbendlin
Super User
2 years ago

not like this - you would have to include six choices rather than two.

 

- local sales

- USD sales

- local budget

- USD budget

- local YTD

- USD YTD