Forum Discussion
Helper I2 different dynamic measures in single table with 2 different slicers
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
Helper IVersion - SF -Base is taking data from column 1 (From table "Version - SF -Base" and column "Base"
Version - SF - Comp 1 is taking data from column 2 (From table "Version - SF - Comp 1" and column "comp 1"
I created this to have 2 differnet slicers.
Super UserHi,
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.
- SagarChauhan1
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- Ashish_Mathur
Use 2 REMOVEFILTERS() in each measure. DIY.
- SagarChauhan1
Thank you so much Ashish for your help to resolved this. It is really helpful and appreciate your time.
- Ashish_Mathur
You are welcome.