Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Missing totals

Hi, I have been having issue of not getting totals in my calculations when using Table visualization or otherwise.   Formulas I am using: 1. _Loadability by cases per trips = CALCULATE( DIVIDE([...
DATEADD
dax measure
Help Requested
Totals
Urgent Help with DAX
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    One approach is to keep your current measures and make new ones with this pattern (assuming you have a YearMonth column in your Date table):

     

    NewMeasure = sumx(Values(Date[YearMonth]), [existing measure])

     

    That should work both in your rows for each YearMonth and for the total.

     

    If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

One approach is to keep your current measures and make new ones with this pattern (assuming you have a YearMonth column in your Date table):

 

NewMeasure = sumx(Values(Date[YearMonth]), [existing measure])

 

That should work both in your rows for each YearMonth and for the total.

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat