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.
Hello! It seems as if my syntax is incorrect:
Measure = calculate(sum(Table[Hrs]),filter(ALL(Table[Billable]), Table[Category]="Time Off"))
I am trying to calculate the days off (Vacation, holidays and sick) for use in an utilization calculation. I want the measure to recognize the time based filters but not filters if it is billable time as there is other non-billable time such as internal meetings.
Thank you for your help!
Solved! Go to Solution.
You may try the measure below.
Measure = CALCULATE ( SUM ( Table1[Hrs] ), ALL ( Table1[Billable] ), Table1[Category] = "Time Off" )
You may try the measure below.
Measure = CALCULATE ( SUM ( Table1[Hrs] ), ALL ( Table1[Billable] ), Table1[Category] = "Time Off" )
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |