Forum Discussion

Anonymous

Not applicable

6 years ago

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

Anonymous

Not applicable

6 years ago

Hey Anonymous

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

Anonymous
Not applicable
6 years ago
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
  Not applicable
  6 years ago
  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/533827 https://community.powerbi.com/t5/Desktop/Total-is-wrong-in-a-matrix/td-
  4. p/348993 https://community.powerbi.com/t5/Desktop/Incorrect-matrix-row-total/td-p/94945
  
  Let me know if any of these help.