Measure Using Multiple Conditions On Multiple tables

[andybamber]

Hello!

Hoping someone can help!

I have attached an example data set below.

What I am trying to do is build a measures with the following logic, which has to look at 2 different tables, apply conditional logic to fields in both tables, and then return a count of the matching rows from the cplan table. 

Condition 1 = COUNTROWS(cplan) WHERE (cplan[UsagePlan] NOT IN {"Plan2","Plan3"}) OR sys_status[Status] = "Active"

 PBIX File 

Cheers

Andy

[tamerj1]

Hi @andybamber 

COUNTROWS ( FILTER ( c_plan, NOT ( c_plan[UsagePlan] IN { "Plan2","Plan3" } ) ) )
    + CALCULATE ( COUNTROWS ( c_plan ), sys_status[Status] = "Active" )

[DimaMD · Accepted solution]

Hi @andybamber 
Is this your desired result?