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

cs_skit's avatar
cs_skit
Icon for Resolver IV rankResolver IV
9 years ago

does this work:

 

CountAinAllCols =
CALCULATE(COUNTROWS(ABCtable);ABCtable[ColumnA]="A") +
CALCULATE(COUNTROWS(ABCtable);ABCtable[ColumnB]="A") +
CALCULATE(COUNTROWS(ABCtable);ABCtable[ColumnC]="A")

  • mellas_k's avatar
    mellas_k
    Icon for Helper I rankHelper I
    9 years ago

    hi cs_skit

    Thanks for your answer but I need to calculate each column separately by regrouping the filter

    Like this for example  :

    measure= (CALCULATE(COUNT(Table [columnA   ]);FILTER(Table; Table[columnA   ]="A"& “B” )))

    but it don't work ..

     

    thanks

    • cs_skit's avatar
      cs_skit
      Icon for Resolver IV rankResolver IV
      9 years ago

      Yeah sorry you need independent of current filter context

       

      CountAinAllCols =
      COUNTROWS(FILTER(ALL(ABCtable);[ColumnA]="A")) +
      COUNTROWS(FILTER(ALL(ABCtable);[ColumnB]="A")) +
      COUNTROWS(FILTER(ALL(ABCtable);[ColumnC]="A"))

      • mellas_k's avatar
        mellas_k
        Icon for Helper I rankHelper I
        9 years ago

        hi cs_skit

        Thanks for your answer ,but probably you don’t understand my request  .. I need to applicate multiple filter for each column I can use this measure:   measure= (CALCULATE(COUNT(Table [columnA   ]);FILTER(Table; Table[columnA   ]="A")))

        it’s work but in my real  table I have 52 column , and for each column I have 3 group of filter ..

        So I need to optimize my work ..

        thanks