Forum Discussion

PWRBI's avatar
PWRBI
Frequent Visitor
3 years ago
Solved

Countrows with Sumx not working

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 w...
countrows sumx
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi PWRBI 
    Please try

    MEASUR =
SUMX (
    VALUES ( STORAGE[BOX] ),
    INT ( CALCULATE ( SUM ( TORAGE[WEIGHT] ) ) < 70 )
)
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi PWRBI 
Please try

MEASUR =
SUMX (
    VALUES ( STORAGE[BOX] ),
    INT ( CALCULATE ( SUM ( TORAGE[WEIGHT] ) ) < 70 )
)
PWRBI's avatar
PWRBI
Frequent Visitor
3 years ago

Thank you very much!!! 🙂 It works😍