how to count distinct values in a column

[JacobStone]

I want to count and display the count of a specific value that appears multiple times in a column.

[Zubair_Muhammad · Accepted solution]

@JacobStone

You can use a MEASURE

cOUNT =
CALCULATE ( COUNT ( Table1[Industry] ), Table1[Industry] = "Manufacturing" )

or

Count =
COUNTROWS ( FILTER ( Table1, Table1[Industry] = "Manufacturing" ) )

[JacobStone]

Many thanks! Really appreciate the fact that you took the time to help. I am new to PowerBI and this was very helpful!

JS.