CountIFs for Data Integrity Report

[Anonymous]

I currently have an excel report that has multiple countifs for each data integrity check. What would be the best way to recreate this in BI? How would I recreate the countifs ? Measures for each 'Integrity Check'? Sample file attached. 

Result of check #1 = 2 jobs meet criteria 

[themistoklis]

@Anonymous 

See a countif formula below:

COUNTIFS =
CALCULATE (
    COUNT( Table[ID]),
    FILTER (
        Table,
        Table[Dim1] = "Value_1"
            && Table[Dim2] = "Value_2"
			&& Table[Dim3] = "Value_3"
    )
)

[Anonymous]

@themistoklis Can this be done using a measure/calc? Still fairly new to BI and still learning.

[themistoklis · Accepted solution]

@Anonymous 

The above formula that i wrote is a measure not a column.

So create a new measure and add the formula