Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

CountIFs for Data Integrity Report

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 

 

 

 

General Comment
Need Help
Tips and Tricks
  • themistoklis's avatar
    themistoklis
    5 years ago

    Anonymous 

     

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

     

    So create a new measure and add the formula

3 Replies

  • themistoklis's avatar
    themistoklis
    Community Champion
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

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

      • themistoklis's avatar
        themistoklis
        Community Champion
        5 years ago

        Anonymous 

         

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

         

        So create a new measure and add the formula