Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to Count Each Value in a Column?

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
 
 
Need Help
  • jgeddes's avatar
    jgeddes
    3 years ago

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

2 Replies

  • jgeddes's avatar
    jgeddes
    Super User
    3 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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