Why does Powerbi not correctly aggregate whole numbers correctly from another table?

[ARomain57]

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?

[v-yilong-msft]

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.

[lbendlin · Accepted solution]

a many to many dimension table

That'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-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...