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 ...
Ahmedx
Super User
Super UserIs 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?
- Ahmedx
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
- Ahmedx
what dates do you want to exclude here, I don’t understand something, this measure gives empty