Measuring across multiple columns for criteria including blanks.

[Danniii_]

So basically I have some data pulled from a form which has 3 different questions that can be answered with either "Yes","No" or can be left Blank.

On the data these questions and their results are shown in 3 different columns, for example...

Column A - Question 1 

Column B - Question 2

Column C  - Question 3 

I am trying to count how many forms have either No or have been left Blank against all 3 questions.

Struggling to get something to work on this one so any advice will be appreciated.

Thanks

[AlB · Accepted solution]

Hi @Danniii_ 

It'd be best to pivot your data. With the structure you have, place this measure in a card visual:

Measure =
COUNTROWS (
    FILTER (
        Table1,
        (
            Table1[Q1] = "No"
                || ISBLANK ( Table1[Q1] )
        )
            && (
                Table1[Q2] = "No"
                    || ISBLANK ( Table1[Q2] )
            )
            && (
                Table1[Q3] = "No"
                    || ISBLANK ( Table1[Q3] )
            )
    )
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Danniii_]

Worked perfectly thank you