Forum Discussion

caiying100126's avatar
caiying100126
Frequent Visitor
6 years ago
Solved

calculate

I have a table named "spend data"  with different Material numbers. For each material number, there are several spends.   I want to sum up the total spend for each material number and count how man...
CALCULATE
  • parry2k's avatar
    parry2k
    6 years ago

    caiying100126 Add following measures 

     

    following # Material over amount measure will give you the count.

     

    Total Spend = SUM ( Table[Spend] )

# Material over amount = 
COUNTX ( VALUES ( Table[Material] ), IF ( [Total Spend] > 100000, 1 ) )

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

caiying100126 Add following measures 

 

following # Material over amount measure will give you the count.

 

Total Spend = SUM ( Table[Spend] )

# Material over amount = 
COUNTX ( VALUES ( Table[Material] ), IF ( [Total Spend] > 100000, 1 ) )