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
In that dataset i also have YTD sales and Budget. I want the parameter to cover all of those options.

You may have wanted to mention this earlier.  In that case I would recommend you invest in a proper data model. Add a Calendar table, as well as a FX table (assuming you have monthly FX rates?) . Then you can use a slicer with the currencies based on the FX table, and for all your measures (Sales, Budget, YTD) you can then compute the right value based on the chosen currnecy and time range.

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