Measure to count across multiple columns

Question

I am new to Power BI - DAX functions.

I have three columns in a table with text in it and I have added a fourth column where I want the count of these three but when I use COUNTA, COUNTX or COUNTAX measure I am getting the count of the entire column.

COUNTA
COUNTAX
COUNTX

Column = COUNTX(Table1, Table1[First_Amendment])
           + COUNTX(Table1, Table1[Second_Amendment])
           + COUNTX(Table1, Table1[Third_Amendment])

Suppose column A, B, C contains three names, apple, mango, oranges respectively so in fourth column I should get count as 3.

In what cases would you not get 3? Are some of the rows blank? — Alexis Olson
– Alexis Olson, Commented Jan 2, 2019 at 18:57

zoe zhi · Accepted Answer · 2019-01-03 03:01:53Z

0

Did you want to count no blank column based on row, right?

If so, you could try to use calculated column like below

Column = if((countaa[a])="",0,1)+if((countaa[b])="",0,1)+if((countaa[c])="",0,1)

You also could refer to this post for details.

Zoe

answered Jan 3, 2019 at 3:01

zoe zhi

1643 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Measure to count across multiple columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related