Forum Discussion

gkakun's avatar
gkakun
Helper 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]<>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 

Capture.PNG

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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

  • 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