Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Sum with filter grand total not working

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 ...
  • Anonymous's avatar
    Anonymous
    8 years ago

    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's avatar
Anonymous
Not applicable
8 years ago

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's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks much!