Forum Discussion
Why does Powerbi not correctly aggregate whole numbers correctly from another table?
I am wondering why Powerbi doesn't Sum/Min/Max a whole number correctly from another table
This is just a rudimentary example, but let's say I have 3 tables as an example. I have a fact table, a many to many dimension table (and I want the dimension table to filter the fact table) and a One to Many Dimension Table, with the dimension table filtering the fact table
In Powerbi, I can bring over all of the data in my fact table, and then when I bring over a whole number, let's say the Calls Made, it doesn't know what to do with them
But when I bring over a column from the Calls Made Table, it works
This also happens in the One to Many Table as well, so I know it isn't something with the relationship. I know that if the Many to Many has Both Cross filter direction, it works properly, but I don't want that.
I've been able to work around it using the TREATAS(VALUES), but I am just curious if there was something else I could do?
a many to many dimension tableThat's not really a dimension table. Dimension tables work best when the key column is unique.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
2 Replies
- lbendlin
Super User
a many to many dimension tableThat's not really a dimension table. Dimension tables work best when the key column is unique.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 - AnonymousNot applicable
Hi ARomain57 ,
Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.