Forum Discussion
Need Help with Measure total incorrect
As the title says I am having an issue with my measure totals. I am coming my raw data to whats in power bi and the vpower bi totals a off by a few units. When I drill down into the data and add up the sub totals I am getting a different total from the grand total.
How can I fix this issue? Please see the measure formulas below.
Non-Facility Total x =
CALCULATE (SUM('PPRRVU24_V1214'[ NON-FACILITY TOTAL]))
Total RVUs per unit =
SUMX('Raw Data', 'Value Measures'[Units] * [Non-Facility Total x])
Hello Anonymous,
Can you please try this approach:
Total RVUs per unit = SUMX( 'Raw Data', 'Raw Data'[Units] * [Non-Facility Total x] )Alternatively, you can force it to calculate correctly at both row and total levels
Total RVUs per unit = SUMX( SUMMARIZE( 'Raw Data', 'Raw Data'[YourUniqueRowIdentifier], "RowRVUs", 'Raw Data'[Units] * [Non-Facility Total x] ), [RowRVUs] )Hope this helps.
1 Reply
Hello Anonymous,
Can you please try this approach:
Total RVUs per unit = SUMX( 'Raw Data', 'Raw Data'[Units] * [Non-Facility Total x] )Alternatively, you can force it to calculate correctly at both row and total levels
Total RVUs per unit = SUMX( SUMMARIZE( 'Raw Data', 'Raw Data'[YourUniqueRowIdentifier], "RowRVUs", 'Raw Data'[Units] * [Non-Facility Total x] ), [RowRVUs] )Hope this helps.