Forum Discussion
Grand total varies depending on fields used in Rows
Hi stuartcoggins ,
Without knowing your model is difficult to pin point the error, since you are using dates on the visualization that is incorrect,.
- do the date column comes from the same table?
- If they come from the same table turn on the show items without data on the visualization (just to see if there are strange values like blanks or other things)
- If it's from a different table, are you sure all values have a date to be related?
- Also check how the relationships are setup.
Remember that context in Power BI and DAX are given by a large number of things not only filters.
To give you an example I add a case of a value that would also did not appear when applying a date but on the categories it was correct, when I looked at the model there was a bi-directional filter on a table that was related with the calendar that filtered out my calendar and my totals.
Not saying this is the case, but if you have the totals correct when there is split and when you do a calculation with a category or a date those change this is for sure related with the way the model is setup.
Hi Miguel,
Thank you for your reply. I can appreciate that it's difficult to solve this without being able to see the model set-up! The date column does come from the same table, so I assume that it can't be related to model set-up.
I checked the 'Show items without data' and it didn't appear to make a difference. And I checked the source data in our data warehouse and there don't appear to be any null values.
So thank you for you help with this but I appreciate it might be difficult to do anything further on this!
Many thanks,
Stuart
Hi Stuart,
As refered without any additional information it's rely hard, context transiction may be happening that it may not realize on the images you provide.
If you want to send some more details on this you can send me a PM and we can try and check this.