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

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