Dax for Get count of distinct rows from measure

[Anonymous]

my table is below

Column1    Coulmn2

A                     1 

A                     1

A                     2

A                     2
A                     2
A                     3

output will be 3 as there are 3 unique rows.

Note: My source is tabular model so i can create only measures in power BI

[gooranga1 · Accepted solution]

Hi @Anonymous 

Create a calculated column that concatenates Column1 and 2 then distinct count that.

Count = Table1[Column1 ] & Table1[Coulmn2]

DistinctRows = CALCULATE(DISTINCTCOUNT(Table1[Count]))

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

One sample for your reference. Here we can create a measure as below.

Measure = SUMX(VALUES(Table1[Column1]),CALCULATE(DISTINCTCOUNT(Table1[Column2])))

[Zubair_Muhammad]

@Anonymous 

May be a MEASURE like

Measure = Countrows(DISTINCT(TableName))

[gooranga1 · Accepted solution]

Hi @Anonymous 

Create a calculated column that concatenates Column1 and 2 then distinct count that.

Count = Table1[Column1 ] & Table1[Coulmn2]

DistinctRows = CALCULATE(DISTINCTCOUNT(Table1[Count]))

[tex628]

Request is a little bit vague but a DISTINCTCOUNT([Column2]) should work i believe?

Br,
Johannes