I have created what i thought was a very simple data model and data table however I am getting strange occurrences - i can send you a data file if you need.
As you can see in this photo, i have a measure which is for revenue then a simple measure which calculates revenue LY and it works exactly as it should and is correct. However, when i remove the context of “adjusted date”, in hopes for a total of revenue rather then a breakdown, it displays 0 for revenue LY.
With date context
Without date context
For some reason i am having weird issues where if there is no date context next to anything it will display 0.
Any help would be great thanks,