Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Issue with Totals for a visual

The Power BI photo is simply a count patients per day and created a date grouping by month.  Each Month the count is correct but the total is not a grand total (possibly the distinct count fo...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

If you wrap your function in SUMX (Values...) it will force the grand total to the sum of the above.

Total Patients Per Day = 
SUMX ( 
    Values( Table3[Month & Year] ), 
    CALCULATE( SUM ( Table3[Patients Per Day] ) )
)