many to many different granularity

Hey powerbiexpert22 ,

the relationship between the ProductDim and TagetFact is NOT active (this is why it's a dotted line that is viusalizing the relationship):

If you change this, you will see this in the table visual immediately:

Be aware that the Clothing data is not 40 because of the typo

Clothing vs

Cothing

in the TagetFact table.

Regards,

Tom

thanks TomMartens  for detailed feedback