Forum Discussion

awolf88's avatar
awolf88
Icon for Helper II rankHelper II
3 years ago
Solved

Wrong Subtotal

Dear geniusses,  I'm having an issue with the sub-totals once again. It seems even CHATGpt can't solve this, so I am praying that perhaps one of you can pin-point me in the right direction.    Sup...
Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    Hi awolf88 ,

     

    Believe what you can do is a new measure with the following code:

    Measure = SUMX(DISTINCT('Calendar'[MonthName]), [S2: YTD + remaining Budget])
     

     

awolf88's avatar
awolf88
Icon for Helper II rankHelper II
3 years ago

Thank you so much, Miguel! Totally did the trick!

 

Best,

Alex