Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Measure to Calculate sum for value in a Column

https://ufile.io/92hq0

 

In the above look is my sample Excel file.

 

I want to create a measure that would calculate the number of Project hours:

 

Case: Category = Project

 

and sum 'Time As a Decimal'

 

How do you do this?

Need Help
Show and Tell

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Perhaps something like this measure:

     

    Measure = 
SUMX(FILTER(ALL('Table'),[Case: Category]="Project"),[Time As Decimal])
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      THat's the correct Greg thank you.

       

      What if I want to add support as well?

      Measure = 
(
SUMX(FILTER(ALL('Table'),[Case: Category]="Project"),[Time As Decimal])
+

SUMX(FILTER(ALL('Table'),[Case: Category]="Support"),[Time As Decimal])
)/40*14

      But I don't trust the number for this calculation.