How to Count Each Value in a Column?

[ahooee]

Hi

I have a column (called "CONCAT 4 Columns") as result of concatenating 4 other columns. Now, I need to get the number of rows having the value in each cell of "CONCAT 4 Columns" column, within the same column ("CONCAT 4 Columns").

I am using the below formula but I am getting "1" in return but as you can see in the screenshot I have 3. What am doing wrong?

COUNT 4 = CALCULATE(

    COUNTA('*Raw: All ARA Users Tables Appended'[CONCAT 4 Columns]),

ALL('*Raw: All ARA Users Tables Appended'[CONCAT 4 Columns]),'*Raw: All ARA Users Tables Appended'[Risk Type]<>""

)

Thanks

Reza

[ahooee]

Many thanks, ALLEXCEPT resolved it. At the end it looks like this:

COUNT 4 = CALCULATE(

COUNTA('*Raw: All ARA Users Tables Appended'[CONCAT 4 Columns]),

ALLEXCEPT('*Raw: All ARA Users Tables Appended','*Raw: All ARA Users Tables Appended'[CONCAT 4 Columns]

))

[jgeddes · Accepted solution]

Try,
CALCULATE(
COUNTA('*Raw: All ARA Users Tables Appended'[CONCAT 4 Columns]),
ALLEXCEPT('*Raw: All ARA Users Tables Appended'[CONCAT 4 Columns]),
)