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 :)