Forum Discussion

Crav888's avatar
Crav888
Frequent Visitor
8 years ago
Solved

Sum Multiple when filtered

Hi,    I have the following data set:   Area  Item  Cost       1        Yes    5 1        Yes    10 1        No    20 2        No    12  2        Yes    13  2        Yes     12   How do I...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this

     

    =CALCULATE(SUM(Data[Cost]),Data[Item]="Yes")/SUM(Data[Cost])

     

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Try this

 

=CALCULATE(SUM(Data[Cost]),Data[Item]="Yes")/SUM(Data[Cost])

 

Hope this helps.