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
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.