Forum Discussion

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

v-piga-msft

Resident Rockstar

7 years ago

Hi data_buzz ,

By my tests with your sample pbix, you need to modify your measure [Material Qty] like below.

Material Qty = 
MAX ( Orders[Qty] ) * CALCULATE ( SUM ( 'Bill of material BOM'[Qty Required] ) )

Then create the [Boxes] and [Pallets ]use SUMX.

Boxes = SUMX('Orders', [Material Qty]/MAX('Storage Configuration'[Box Qty]))
Pallets = SUMX('Orders', [Material Qty]/MAX('Storage Configuration'[Pallet Qty]))

Here is the output.