Forum Discussion

SagarChauhan1's avatar
SagarChauhan1
Icon for Helper I rankHelper I
2 years ago
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. ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    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.

     

  • SagarChauhan1's avatar
    SagarChauhan1
    2 years ago

    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's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

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?

SagarChauhan1's avatar
SagarChauhan1
Icon for Helper I rankHelper I
2 years ago

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)

  • SagarChauhan1's avatar
    SagarChauhan1
    Icon for Helper I rankHelper I
    2 years ago

    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.


    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      2 years ago

      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.

       

      • SagarChauhan1's avatar
        SagarChauhan1
        Icon for Helper I rankHelper I
        2 years ago

        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