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

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])
)