Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a table that contains 2 types of records (Audits and Observations). I am trying to use a measure to count the total number of Audits records.
Hi @huguest,
How about:
DistinctCountAudit_All_Categories = CALCULATE(DISTINCTCOUNT('Audits_and_Obs'[ID]),'Audits_and_Obs'[Type]="Audit",ALL('Audits_and_Obs'))
Best regards,
Yuliana Gu
Hi @huguest,
Would you please kindly share your solution so that it can benefit other community members having similar problem?
Regards,
Yuliana Gu
Hi @huguest
Can you share the pbix? It'd be much easier to see what is going on.
OK, that's going to be hard then.
Is the visual level filter on 'Audits_and_Obs'[Category] as well? Or perhaps a [Category] from another table?
It's tough to guess what might be going on like this.Could you maybe share a simple pbix with dummy data, to avoid the confidentiality issues, that reproduces the problem? Not sure if that will be worth your while.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |