Forum Discussion

mellas_k's avatar
mellas_k
Helper I
9 years ago
Solved

How to use a multiple filter on the same column

hello , I need your help to optimize my work … I will give you the below table to explain my problem   Table : columnA   columnB  column A               A                    A A               B...
Need Help
  • mellas_k's avatar
    mellas_k
    9 years ago

    hi cs_skit

    Maybe you don’t understand me but with your example you give me what I need ..

    Just I need to add {in}

    measure= (CALCULATE(COUNT(Table [columnA   ]);FILTER(Table; Table[columnA ] IN{"A";"B")))

    And now I can do many filter on the same column

    thanks :)

cs_skit's avatar
cs_skit
Resolver IV
9 years ago

you are right I seem to be too stupid to understand what you want to do

 

maybe this?

 

CountSpecialinAllCols =

COUNTROWS(FILTER(ALL(ABCtable);[ColumnA] IN{"A";"B"})) +
COUNTROWS(FILTER(ALL(ABCtable);[ColumnB] IN{"A";"B";"XYZ"})) +
COUNTROWS(FILTER(ALL(ABCtable);[ColumnC] IN{"B";"C";"uniquestuff"}))

mellas_k's avatar
mellas_k
Helper I
9 years ago

hi cs_skit

Maybe you don’t understand me but with your example you give me what I need ..

Just I need to add {in}

measure= (CALCULATE(COUNT(Table [columnA   ]);FILTER(Table; Table[columnA ] IN{"A";"B")))

And now I can do many filter on the same column

thanks :)

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Worked, but please write the code correctly 

     

    Measure = CALCULATE(COUNT(CoulmnName), FILTER(Table, ColumnName IN {"A","B","C"}))