Forum Discussion

Chandrashekar's avatar
Chandrashekar
Icon for Resolver III rankResolver III
3 years ago

Wrong Table Total

Hello,   am getting wrong total(am getting 5815 instead of 6584) .   I am using below measure for calcuation.   Measure1 EIP = CALCULATE(COUNT('MS'[u_number]),USERELATIONSHIP('MS'[DateOp...
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Chandrashekar 

this happens because one item could present at different categories and is thus counted 1 in each category. But at the total row, it is counted only 1. 

Chandrashekar's avatar
Chandrashekar
Icon for Resolver III rankResolver III
3 years ago

Hello,

 

How to fix this issue to get exact count.

 

Regards,

Chandrashekar B