Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Perhaps something like this measure:
Measure = SUMX(FILTER(ALL('Table'),[Case: Category]="Project"),[Time As Decimal])
@Nusc ,
You may take a look at https://www.sqlbi.com/articles/the-in-operator-in-dax/.
Perhaps something like this measure:
Measure = SUMX(FILTER(ALL('Table'),[Case: Category]="Project"),[Time As Decimal])
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.
@Nusc ,
You may take a look at https://www.sqlbi.com/articles/the-in-operator-in-dax/.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |