Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I have the below chart, for example. I know I have 8 distinct inspection #s but what I want to calculate is how many of those 8 inspections have a "1" in the "Item Found" column. The answer should be 6.
Any help is appreciated.
Thanks
Solved! Go to Solution.
Hi @RobKay12 ,
Please try to create a measure with below dax formula:
Measure =
COUNTROWS (
FILTER (
SUMMARIZE ( ALL ( 'Table' ), 'Table'[inspection], 'Table'[item found] ),
[item found] = 1
)
)
Please refer the attached .pbix file.
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @RobKay12 ,
Please try to create a measure with below dax formula:
Measure =
COUNTROWS (
FILTER (
SUMMARIZE ( ALL ( 'Table' ), 'Table'[inspection], 'Table'[item found] ),
[item found] = 1
)
)
Please refer the attached .pbix file.
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If that worked then it would give me a count of 7 not 6.
Hi there,
You could use a Power Automate to look into the column and with a condition count all the the ones that are not 0(zero).
Cheers,
Fernando
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
95 | |
86 | |
76 | |
64 |
User | Count |
---|---|
138 | |
113 | |
109 | |
98 | |
93 |