Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Simple count measure generating wrong rows values on table visual

Hello everyone, hope you're having a nice day.   I am having a very strange problem in here. To delimit the borders of the case, lets say i have a model like this:     And with that, i wan...
data protection
v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

This could be caused that there have been multiple many-to-many relationships in your data model so that power bi could not distinguisih it clearly when calculating.

You can try to use bridge table to change many-to-many to one-to-many relationship or change the filter direction in many-to-many relationships to check. 

Please refer: Apply many-many relationships in Power BI Desktop 

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.