Forum Discussion

gkakun's avatar
gkakun
Icon for Helper III rankHelper III
8 years ago

Total does not match

Hi all,   I have an issue with total row in a table. I have this report, while the measures is use as follow:   Total= CALCULATE(DISTINCTCOUNT('FR Detailed'[KeyColumn]),'FR Detailed'[KeyColumn]<...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Maybe you would have checked this, still want to ask you :  your report CMP count 203 is the distinct count. Did you check the actual 538 is distinct ? If not instead of distinctcount, please use count if you want to count duplicate also.

 

Thanks
Raj