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

[Anonymous]

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

[Anonymous · Accepted solution]

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:

[v-yuta-msft · Accepted solution]

@Anonymous ,

Or you can just use measure 

Result = COUNT('Table'[Lang])

 

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.

[Anonymous · Accepted solution]

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: