Forum Discussion

mellas_k's avatar
mellas_k
Icon for Helper I rankHelper 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 :)

mellas_k's avatar
mellas_k
Icon for Helper I rankHelper 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"}))