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

[quentin_vigne]

Hi @gkakun

What method did you choose to display ? SUM ? Count ? Distinct count ? 

- Quentin

[gkakun]

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" .

[quentin_vigne]

@gkakun

Can you do it again but as a column ? (Not sure about this)

- Quentin

[gkakun]

i dont have a way to calculate it as a column. It must be measure