Forum Discussion

ide's avatar
ide
Regular Visitor
5 years ago
Solved

Calculate switching between brands

Hi guys,   Is it possible to make following thing happen....   What data i have: Brand sum Brand_A 2309 Brand_B 2342 Brand_C 1234 Brand_D 257   What i want to build in p...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi ide ,

     

    Create four measures similar to this

    Brand A = SUM('Table'[Sum])-
 CALCULATE(SUM('Table'[Sum]),FILTER(ALLSELECTED('Table'),'Table'[Brand]="Brand_A" ))

    Sample .pbix

     

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

ide's avatar
ide
Regular Visitor
5 years ago

How it can be, in excel example

 

 

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi ide ,

 

Create four measures similar to this

Brand A = SUM('Table'[Sum])-
 CALCULATE(SUM('Table'[Sum]),FILTER(ALLSELECTED('Table'),'Table'[Brand]="Brand_A" ))

Sample .pbix

 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.