Measure to Calculate sum for value in a Column

[Anonymous]

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?

[Greg_Deckler · Accepted solution]

Perhaps something like this measure:

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

[Greg_Deckler · Accepted solution]

Perhaps something like this measure:

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

[Anonymous]

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.

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may take a look at https://www.sqlbi.com/articles/the-in-operator-in-dax/.