Forum Discussion
No correct calculation rows
Hi,
I am making a new report and everting works fine except the teamreport. If I select a teammember which moven from team x to team y it shows the correct month figures but not the totals. The totals are for the both rows the same. Do you have a solution?
5 Replies
How member movement from one team to another is taken care ?
Here is the datamodel. Make it it simple
When the contract changes. The data presents it at the end of the mont in the table contracts. The dates in the declarations have alle the dates in the month.
Hope this makes it clear. amitchandak Anonymous
Hey Anonymous
There are a couple possible problems, but the below articles should address any of the instances which you may be experiencing.
1. https://www.burningsuit.co.uk/blog/2018/07/dax-is-the-total-row-in-a-table-giving-you-grief/
2. https://community.powerbi.com/t5/Desktop/Rows-and-Column-Totals-are-wrong-in-a-Power-BI-Matrix/td-
3. p/533827https://community.powerbi.com/t5/Desktop/Total-is-wrong-in-a-matrix/td-
4. p/348993https://community.powerbi.com/t5/Desktop/Incorrect-matrix-row-total/td-p/94945
Let me know if any of these help.
Hi, Anonymous
I assume that there is something wrong with your data model. I'd like to suggest you use a star schema instead of circle schema.
Cross filtering both directions works well for a pattern of table relationships such as the pattern above. This schema is most commonly called a star schema, like below:
If you have a table pattern like below, with loops, then cross filtering can create an ambiguous set of relationships. For instance, if you sum up a field from TableX and then choose to filter by a field on TableY, then it’s not clear how the filter should travel, through the top table or the bottom table.
For further information, please refer to the official document .
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
