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 ) )

     

amitchandak's avatar
amitchandak
Super User
6 years ago
Total Spend = SUM ( Table[Spend] )
Measure = CALCULATE(COUNTX(FILTER(VALUES(Table[Material]),[Total Spend]>=1000),[Total Spend]))