Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply

Grand Total of measure doesn't equal sum of row values

So i've done quite a bit of research.  I've found that my measure is calculating by row properly:

 

YTD.sample.2 = 
 CALCULATE(
     IF([YTDEarn]-[Period.Earn]>7000 ,[Period.Earn]*[Bonus %]
         ,IF([YTDEarn]>7000,([YTDEarn]-7000)*[Bonus %],0))
     ,FILTER(VALUES(SALES[SALES_PERSON]),[YTDEarn]>7000))

When viewing data in table, grand total is not the sum of rows.  Row total is 2076.5381 Grand Total displays 2470.  

 

As a side note i've noticed that all earnings are being sum (regardless of the second condition) when viewing the grand total.

 

TIA .csv File

 

 

 

 

 

 

 

 

Power BI resultsPower BI resultsSpreadsheet ResultsSpreadsheet Results

1 ACCEPTED SOLUTION
v-yulgu-msft
Employee
Employee

Hi @KUNGFUPANDA559,

 

Please try the method provided in below thread:

Dealing with Measure Totals

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-yulgu-msft
Employee
Employee

Hi @KUNGFUPANDA559,

 

Please try the method provided in below thread:

Dealing with Measure Totals

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

OMG when i tell you thank you. . .  This is exactly what I was looking for!

For the values that are NOT YTDEarnings-PeriodEarnings>7000 current filter is multipying the full period earnings by Bonus amount.  I'm just unsure of how to get it to calculate grand total based on row totals (sumx?)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.