Countrows with Sumx not working

[PWRBI]

Hi guys,
I have the following data

Storage	Box	package	weight
A	A1	A101	30
A	A1	A102	20
A	A2	A201	40
A	A2	A202	30

Storage A has a capacity of 70. Now I would like to display in an additional table how many boxes in warehouse A still have free capacity. In the above example, this would be box A1 because 20 are still free, A2 is full with 70.

Storage	Free boxes
A	1

This is my Measure:

MEASURE =

VAR VAR1 = CALCULATE( SUMX( SUMMARIZE('STORAGE', STORAGE[STORAGE], STORAGE[BOX], "SCORE", sum(STORAGE[WEIGHT]), [SCORE] ))
VAR VAR2 = COUNTROWS(FILTER(DISTINCT(STORAGE[BOX]), VAR1< 70))

return VAR2

It works when I look at the box level, but when I want the total across all Storages, nothing shows up, so the total row doesn't match. What do I have to change?

[tamerj1 · Accepted solution]

Hi @PWRBI 
Please try

MEASUR =
SUMX (
    VALUES ( STORAGE[BOX] ),
    INT ( CALCULATE ( SUM ( TORAGE[WEIGHT] ) ) < 70 )
)

[PWRBI]

Can you help me in this case too? 🙂

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Summarize-in-DAX-HELP/m-p/3316484#M1...

[PWRBI]

Thank you very much!!! 🙂 It works😍