No correct calculation rows

[Anonymous]

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?

[v-alq-msft]

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.

[Anonymous]

Hey @Anonymous 

What kind of data source are you using and what aggregation is applied to the values in the visual?

[Anonymous]

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 

[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.

[amitchandak]

How member movement from one team to another is taken care ?