Forum Discussion
Totals row miscalculation
I have a measure called "Percent Complete" which divides one measure from another and creates a percentage. In my numerator, "Total Invoiced", the measure sets all null values to be $0. My "Percent Complete" measure shows 0% for rows where this is the case, as desired.
The issue lies in the totals row. Instead of applying the calculation to the totals of Invoiced and Budget, the measure only calculates for rows which have a non-null value.
How can I get the totals row for my "Percent Complete" column to show the correct calculation based on the totals?
1 Reply
Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
