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 A...
Need Help
Show and Tell
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.