Forum Discussion
2 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
1st Column answer should be 237,177 (If we select "ACT 2023" in slicer Base"
2nd Column answer should be 252,348 (If we select "AOP 2023" in slicer Comp 1"
I cannot understand why the Data Model is so complex. Why in the first place are there multiple "Version - SF - Comp 1" tables? Also, in each of those tables, where are there 3 columns?
They all are same, but i thought we needed 2 different slicers hence created "Version - SF -Base" for Base 1 field and "Version - SF - Comp 1" for Comp 1 field. (Ignore "Version - SF - Comp 2") (You can remove it as required)
Version - 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.