Hello DAX friends
I am a newbie and learning my DAX steps here. I am running into an issue with my Totals. I have looked at the sample video and could not apply the same to my model. Hope someone can help me out in this forum.
I have the transactions in the shipment table. The target shipment for customers are in another table. My visual should show the last Year shipment in Pallet, Target % and the Estimated Shipment( Last year shipment + TArget%) . My individual rows are calculated correctly , but the Grand total is showing wrong.
The attached PBIX file is not showing the issue. Unfortunately, I cannot put my Pbix in public due to security reasons. I had seen the summarize option used in the forum, but i am having trouble in applying that in to this model.
I was not sure if i am using the right approach to show the estimated total. Please advice.