Total does not match

[gkakun]

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]<>BLANK())

SRT= CALCULATE(DISTINCTCOUNT([KeyColumn]),'FR Detailed'[FR Status]="SRT")

SLD= CALCULATE(DISTINCTCOUNT([KeyColumn]),'FR Detailed'[FR Status]="SLD")

SFF= CALCULATE(DISTINCTCOUNT([KeyColumn]),'FR Detailed'[FR Status]="SFF")

LDC= CALCULATE(DISTINCTCOUNT([KeyColumn]),'FR Detailed'[FR Status]="LDC")

CMP= CALCULATE(DISTINCTCOUNT([KeyColumn]),'FR Detailed'[FR Status]="CMP")

While CMP/LDC/SFF/SLD/|SRT are statuses and the Key is just row identifier.

as you can see in the print screen the total is 207 while the actual is 544 and the CMP is 203 while the actual is 538.

also the FR% is wrong since it should be CMP/Total 

[Anonymous]

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

[Anonymous]

since we dont know your data, could you please post sample data and what you are getting as your output along with expected output?

Thanks

Raj