Forum Discussion

EVG-Questions's avatar
EVG-Questions
Frequent Visitor
4 years ago
Solved

How to filter ID values containing specific values

This is a follow-up to a different question I had, which was solved by @PaulDBrown. I'm trying to find all ID values containing specific values. Example given here: In this example I need to ...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Apologies...I was overthinking this. Try:

     

     

    Only A or D =
VAR _Table =
    CALCULATETABLE (
        VALUES ( 'FactTable'[Cat1] ),
        ALLEXCEPT ( FactTable, FactTable[ID] )
    )
VAR _Vals = { "A", "D" }
VAR _Excpt =
    EXCEPT ( _Table, _Vals )
RETURN
    IF ( COUNTROWS ( _Excpt ) >= 1, 0, 1 )

     

     

     

PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

Apologies...I was overthinking this. Try:

 

 

Only A or D =
VAR _Table =
    CALCULATETABLE (
        VALUES ( 'FactTable'[Cat1] ),
        ALLEXCEPT ( FactTable, FactTable[ID] )
    )
VAR _Vals = { "A", "D" }
VAR _Excpt =
    EXCEPT ( _Table, _Vals )
RETURN
    IF ( COUNTROWS ( _Excpt ) >= 1, 0, 1 )

 

 

 

EVG-Questions's avatar
EVG-Questions
Frequent Visitor
4 years ago

Thanks so much!