Forum Discussion

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

Total row 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 

Need Help

4 Replies

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

      Hi Quentin,

       

      Since it's a measure I cant choose the CMP colum for exampe to be SUM. in the data model it calculated as distinct count for the relevant rows, but the total present it in the wrong way. the total should presented as sum of all the "CMPs" .