Forum Discussion

andybamber's avatar
andybamber
Helper III
4 years ago
Solved

Measure Using Multiple Conditions On Multiple tables

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, ap...
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi andybamber 

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