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 want to create a simple table like this, on which i acomplish using the visual count for the employee_daily production column:

 

If i try to do exactly the same thing using a measure of this same column, with this formula:

employee_daily_production_measure = COUNT('fact_table_1'[order_created])
 
I got this:
 

Any idea why is this happening? This estructure is a simple example. In practical, i have + 10 fact tables with a lot of measures. Create table visuals only based on visual count/sum is not viable.

 

Thanks in advance.

Data Protection

1 Reply

  • v-yingjl's avatar
    v-yingjl
    Community 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.