Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Totals not aligning - Aggregation issues?

Hello everyone,   I'm having some trouble here with how the totalling works within PowerBI.   The main point: When i export the dataset from the matrix widget and perform totals to the columns I ...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
6 years ago

Hi Anonymous ,

If I understand your scenario correctly that the total is not correct when you create the matrix in excel with the dataset in power bi?

By my tests with the latest version of power bi, I cannot reproduce your issue.

If it is convenient, could you share a simple data sample which could reproduce your scenario so that we could have a test on it?

Best  Regards,

Cherry

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-piga-msft Cherry,

 

Thanks for getting back to me. I am trying to upload a file but it doesn't seem like I can. I am assuming there is something wrong with the dax I am using though. It appear that on a client level the dax works correctly. I have provided a screenshot below. Ou can see when know values exist in columns C + D (current period) it ignores the amounts in columns E + F (prior period) and returns a like for like value of 0 in columns G + H. However, on aggregate we can see that the totals are the same in the PowerBI matrix widget and different in the excel version???