Data table in variable

Hi Dudeman123 ,

Thanks for bhanu_gautam's reply!

And Dudeman123 , here may be a simpler DAX. Here is my sample data:

Then use this DAX to create a measure:

Count No = 
SUMX(
    Applications,
    VAR CatA = Applications[Category A] = "Yes"
    VAR CatB = Applications[Category B] = "Yes"
    VAR CatC = Applications[Category C] = "Yes"
    RETURN
    IF( CatA || CatB || CatC, IF( Applications[Objective 1] = "No", 1, 0 ) ) +
    IF( CatA || CatB, IF( Applications[Objective 2] = "No", 1, 0 ) ) +
    IF( CatA, IF( Applications[Objective 4] = "No", 1, 0 ) ) +
    IF( CatB || CatC, IF( Applications[Objective 5] = "No", 1, 0 ) )
)

And the final output is as below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.