Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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. 

 

 

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.
grand total
incorrect
total
wrong
  • bcdobbs's avatar
    bcdobbs
    4 years ago

    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.

2 Replies

  • bcdobbs's avatar
    bcdobbs
    Community Champion
    4 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi bcdobbs ,

       

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