Sum with filter grand total not working

[Anonymous]

Yes this is my first post and I am new to Power BI.  I am developing a utilization report and I have a table with dates and work hours in it along with a bunch of other stuff like if it is a weekend etc.  Basically I am comparing the number of hours worked from timecards compared to the number of working hours for that day to come up with a utilization.  I have a measure with a filter that works fine on the row but the grand total is simply displaying the max value.

520 Hours is correct if the employee worked the entire quarter so I am getting the results I want on the row but I need grand totals and the ability to calculate based on the grand total in other visuals.

Thanks for any help you can offer 🙂 

Den = CALCULATE (SUM ( DateDimension[Hours] ),FILTER (Util,Util[Transaction Date] >= min(Util[Transaction Date])
&& Util[Transaction Date] <= MAX(Util[Transaction Date])))

 

[Anonymous · Accepted solution]

@Anonymous,

Create a new measure using DAX below then check if the measure returns correct grand total.

Measure = IF(COUNTROWS(VALUES(YourTable[Employee ID]))=1, [Den],SUMX(VALUES(YourTable[Employee ID]),[Den]))

Regards,
Lydia

[Anonymous]

Thanks much!