Forum Discussion

data_buzz's avatar
data_buzz
Frequent Visitor
7 years ago

How to Sum measures in my example.

Hi All,    I am trying to SUM measures and display them as cards (Pic Below), but I can't figure out the way how to sum measures in my example.   Link to Power Bi file - https://gofile.io/?c=JNTWh...
Need Help
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
7 years ago

data_buzz 

 

what  i am trying to understand here is what you aren't able to do, i can see you have summed box and if i put a date slicer in it shifts the amounts.

 

what are you expecting that is different from what you are showing here.  

data_buzz's avatar
data_buzz
Frequent Visitor
7 years ago

vanessafvg 

 

At this moment SUM of the measures for Boxes is not what I want. 

 

Current:  = 400 

I would like: 20+30+22+200+300+220+24+31+48 = 895

 

I tried to create measure: 

       

Box Totals =
SUMX('Bill of material BOM',
     [Boxes])  ------- result not what I want
 
...then I have tried: 
 
SUMX(
    VALUES('Bill of material BOM'[Components Nr]),
     [Boxes])) -------- result not what I want. 
 
....run out of options unfortunately.
 
Thanks

 

 

 

Thanks

  • vinaypugalia's avatar
    vinaypugalia
    Icon for Resolver I rankResolver I
    7 years ago

    data_buzz 

    I see what you are expecting but you will never get it this way. The basic reason being the context of your measure changes when plotted as a card Vs when you plot it in the table.

     

    For e.g. the MAX() which you will get for each row will be different than the MAX() which you will get for the card.

     

    I can get you the right DAX if you can share the sample pbix file so that I need to prepare the sample data. And it will help others too if they want to help you.

     

    Looking forward to hear from you.

     

    Thanks!

    • vanessafvg's avatar
      vanessafvg
      Icon for Community Champion rankCommunity Champion
      7 years ago

      vinaypugalia correct, you got to this before me so i will leave you to do it rather than duplicating effort.

    • data_buzz's avatar
      data_buzz
      Frequent Visitor
      7 years ago

      vinaypugalia

       

      Hi there, 

       

      Did you had any luck with DAX for my example ? 

       

      Thanks