Forum Discussion
Solved
2 different dynamic measures in single table with 2 different slicers
I need your help with power BI where i want 2 different dynamic measures (Base Sales & Comparision Sales) in single table with 2 different slicer (Actuals version) and Plan version) for each. ...
Hi,
Simplify the Sales measure to
Sales = DIVIDE(Switch (SELECTEDVALUE('LC-USD Switch'[Currency]), "Local", calculate (sum ('Master Data'[Value (LC)]),'Master Data'[Measure] = "Sales"), "USD", calculate (sum ('Master Data'[Value (USD)]),'Master Data'[Measure] = "Sales")),[Roundings])Revise the measure to
Base 1 Sales = Calculate ([Sales],REMOVEFILTERS('Version - SF - Comp 1'))Comp 1 Sales = Calculate ([Sales],REMOVEFILTERS('Version - SF -Base'))Hope this helps.
Hi,
It works well for 2 tables but when i add comp 2 measure then it is not working properly. I have used the bellow formula for Comp 2. Pls advice
Upload the file to Google Drive and share the download link here.