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

      • cs_skit's avatar
        cs_skit
        Icon for Resolver IV rankResolver 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"}))