cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
celestine_n
Frequent Visitor

Incorrect Total

Hi, I am dealing with the common problem of not having my totals add up correctly and I am unsure how to amend it. 

 

incorrect_totals.png

 

Please see the measure below where I am trying to find the number of outstanding days.

 

Outstanding Days =
IFERROR(
(COUNT(DIM_Calendar[Days in Month])/('Measures Table'[Actual_Sales]/'Measures Table'[Average AR])),
BLANK()
)+0
 
Would appreciate if any help is given! 🙂
 
Thank you.
1 ACCEPTED SOLUTION
bcdobbs
Super User
Super User

Hi,

I think you want to wrap that measure in a SUMX iterating over the sales reps.

 

eg

SUMX(

 VALUES(Table[Sales Reps]),

Your Measure

)

 

on rows where there is only one sales rep it returns the existing value. On the total row it adds up each in turn.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

View solution in original post

2 REPLIES 2
bcdobbs
Super User
Super User

Hi,

I think you want to wrap that measure in a SUMX iterating over the sales reps.

 

eg

SUMX(

 VALUES(Table[Sales Reps]),

Your Measure

)

 

on rows where there is only one sales rep it returns the existing value. On the total row it adds up each in turn.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Hi @bcdobbs ,

 

Thanks alot. You've helped me figure out what was missing! You're amazing, have a great day! 👏😊

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors