Formula Needed

[RobKay12]

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

[v-binbinyu-msft · Accepted 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.

[RobKay12]

If that worked then it would give me a count of 7 not 6.

[fernandosilvauk]

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