Help With Calculation

[Anonymous]

Hello,

I want to calculate the number of different "Lotno" that each different "product no" has.

As an example, the calculation result of the above table should be 6.

Thank you,

Koray

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

sumx( values(Table[product no]), calculate(distinctcount(Table[Lotno])))

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.

[Anonymous]

Thank you so much @amitchandak