How to use a multiple filter on the same column

[mellas_k]

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                    B

B               B                    C

C               C                    D

From this table I need to calculate for each column the count of A , B and C

So I use this measure to calculate the number of “A” on columnA

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

Can you please help me if there is any other possibility to regroup filter on the same measure …

Best Regards 

[cs_skit]

does this work:

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

[mellas_k]

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]

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]

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]

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 · Accepted solution]

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]

Worked, but please write the code correctly 

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

[cs_skit]

glad to be of help 🙂

also SWITCH statement can be nice for filters

https://www.youtube.com/watch?v=-ykkaAtlCMc