Forum Discussion

DeeBali's avatar
DeeBali
Helper I
2 years ago
Solved

Multiple Filters OR on multiple columns from multiple tables

Hello Fabric Community,   I need some assistance in solving a calculation I am attempting. So I am trying to count Name column in one of my tables called "MasterList" based on filters across multip...
lbendlin's avatar
lbendlin
Super User
2 years ago

Fair enough.  In that case do a distinctcount over the Union of these tables.

 

NON COMPLIANT = distinctcount(union(
                                  Filter(Values(MasterList[Name]),AD[In SCCM]="No"), 
                                  Filter(Values(MasterList[Name]),SCCM[In AD]="No"),
                                  Filter(Values(MasterList[Name]),Defender[Onboarded]="No"),

                                  Filter(Values(MasterList[Name]),Purview[Onboarded]="No" ),

                                  Filter(Values(MasterList[Name]),InTune[Onboarded]="No"),

                                 Filter(Values(MasterList[Name]), MasterSecureBaseline[State] ="Yes")
                                ))

DeeBali's avatar
DeeBali
Helper I
2 years ago

Sir, this is the error I recicved:

 

 

 

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    fair enough

     

    NON COMPLIANT = countrows(distinct(union(
                                      Filter(Values(MasterList[Name]),AD[In SCCM]="No"), 
                                      Filter(Values(MasterList[Name]),SCCM[In AD]="No"),
                                      Filter(Values(MasterList[Name]),Defender[Onboarded]="No"),

                                      Filter(Values(MasterList[Name]),Purview[Onboarded]="No" ),

                                      Filter(Values(MasterList[Name]),InTune[Onboarded]="No"),

                                     Filter(Values(MasterList[Name]), MasterSecureBaseline[State] ="Yes")
                                    )))

    • DeeBali's avatar
      DeeBali
      Helper I
      2 years ago

      Hello Sir, thank you for your assistance. Witht his new DAX commands, I get below error:

       

      And for clarification, I did chnage the table name from MasterSecureBaseline to SBMissing as that is table I need to use. I I did do summarization on the State column in the SBMissing table and others as well:

      Thank you.