Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |