Same value for drill downs

Hi afaro 

Check the relationship among the tables, if the relationship is right, that may be the case that the number of customers under the item is the same, and you can check whether the number of customers under a certain item is the same.You can refer to the sample I provided.

I create three tables:customer and sales

Customer

Sales

The relationship

I create a measure

Measure = COUNTROWS(Sales)

Then put them to the visual when I drill down it will diaplay 1 for each customer, after verify, the result is right, becasue some customer only has 1 counts.

2.If the result verification is incorrect，try the following measure

Sales Orders =
CALCULATE (
    COUNTROWS ( sales ),
    CROSSFILTER ( dimensiontable[order number], facttable[order number], BOTH )
)

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.