YTD value not showing sub total

DAX DAX Calculations
2

Hello @neilonbooysen,

Thank You for posting your query onto the Forum.

To fix the grand totals write a small measure. Below is the measure provided for the reference -

Prior Sales - Totals =
SUMX(
   SUMMARIZE(
       Dates , 
       Dates[Date] , 
       "@Totals" , 
       [Prior Sales] ) , 
   [@Totals]
)

I’m providing a link below of the post which one of our expert has created onto the forum which addresses specifically this type of issue. Below is the link of that post provided for the reference.

Hoping you find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Note: Please incorporate the naming conventions accordingly as per your file.

Thanks and Warm Regards,
Harsh

1 Like