Forum Discussion
Totals calculating incorrectly
Hello, I have the following formula which determines whether actuals or forecast should populated the months column. Each individual month column returns correct values but the total column returns ...
Is this what you are looking for?
you need to create a new measure and refer to your measure
https://1drv.ms/u/s!AiUZ0Ws7G26Rh0qcF1eO3MsAIeB1?e=nH0sOm
Thanks Ahmedx , I tried this using my original data. It returns everything as 0. Would you happen to know the cause for it?
I don't know, maybe it's because of the connection in the model, or the filter action. need to see your file
Thanks Ahmedx, Updated file to show my error: Testing.pbix
