Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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" .
i dont have a way to calculate it as a column. It must be measure
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |