cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bcwan Frequent Visitor
Frequent Visitor

Measure in DAX: How to count rows of column A with same value based on unique ID in (column B)

Hello,

 

I'm still fairly new to using DAX in PowerBI. I was wondering how I can count number of rows based on a unique value.

 

So for instance:

 

Table 1

Class  |   Lang

------------------

 1      |   English

 1      |   English

 1      |   English

 1      |   Chinese

 2      |   Italian

 3      |   Arabic

 3      |   Arabic

 3      |   Chinese

 

What I was hoping for:

Resulting measure "Result"

Class  |   Language  |   Result

---------------------------------------

1        |   English      |    3

1        |   Chinese     |    1

2        |    Italian       |    1

3        |    Arabic       |   2 

3        |    Chinese    |    1

 

How can I create the measure "Result" in DAX based on the example diagrams above?

 

Thanks

2 ACCEPTED SOLUTIONS

Accepted Solutions
maguilarBI Regular Visitor
Regular Visitor

Re: Measure in DAX: How to count rows of column A with same value based on unique ID in (column B)

You don't need to create the measure "result" to do that, you only have to add "Lang" again to values pane and select "count" option fos this.

 

See the example:

 

count.png

Community Support Team
Community Support Team

Re: Measure in DAX: How to count rows of column A with same value based on unique ID in (column B)

@bcwan ,

 

Or you can just use measure 

Result = COUNT('Table'[Lang])

Capture.PNG 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
maguilarBI Regular Visitor
Regular Visitor

Re: Measure in DAX: How to count rows of column A with same value based on unique ID in (column B)

You don't need to create the measure "result" to do that, you only have to add "Lang" again to values pane and select "count" option fos this.

 

See the example:

 

count.png

Community Support Team
Community Support Team

Re: Measure in DAX: How to count rows of column A with same value based on unique ID in (column B)

@bcwan ,

 

Or you can just use measure 

Result = COUNT('Table'[Lang])

Capture.PNG 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.