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.
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.
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 | |
78 | |
68 | |
55 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |