Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 t...
Need Help
  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    2 years ago

    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.

Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
2 years ago

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.