Forum Discussion

Varshi288's avatar
Varshi288
Icon for Resolver II rankResolver II
1 year ago
Solved

Switch 3 measures with one click

Hi All,  I want to show 3 measures old or new with the toogle switch.This can be done with bookmarks and it is woking right now.to implemet this in number of pages with different filter contex...
Need Help
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    Hi Varshi288 ,

    Thank you for reaching out to Microsoft Fabric Community.

    Thank you burakkaragoz for the prompt response.

    I have replicated the scenario using sample data.Please go through the attached PBIX file for your reference.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

    Thank you.

v-venuppu's avatar
v-venuppu
Icon for Community Support rankCommunity Support
1 year ago

Hi Varshi288 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you burakkaragoz for the prompt response.

I have replicated the scenario using sample data.Please go through the attached PBIX file for your reference.

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

Varshi288's avatar
Varshi288
Icon for Resolver II rankResolver II
1 year ago

HI v-venuppu  thank you for your detailed inputs on my issue. I managed solve the issue with different  approch.

SP CM Scope = Var _SPCM_excl_oDC =CALCULATE(SUM(Data[SP $ (calc)])-sum(Data[DM (USD)])-sum(Data[DL (USD)])-sum(Data[Adjustment]),KEEPFILTERS(PU[PU]<>"elim"))
       Var _SPCM_Incl_oDC = CALCULATE(SUM(Data[SP $ (calc)])-sum(Data[DM (USD)])-sum(Data[DL (USD)])-sum(Data[Adjustment])-SUM(Data[oDC (USD)]),KEEPFILTERS(PU[PU]<>"elim"))
return
IF(ISCROSSFILTERED('Selected Measure'[CM Scope]),
    SWITCH( TRUE(),
  VALUES('Selected Measure'[CM Scope])= "Excl other DC", _SPCM_excl_oDC,
  VALUEs('Selected Measure'[CM Scope])= "Incl other DC", _SPCM_Incl_oDC),
  _SPCM_excl_oDC)

Thnaks once again.