Count unique distinct values of two columns

[SG-01]

Hi,

I have the following data:

Season	Round
2021	1
2022	1
2021	2
2022	2
2021	3

The combination of Season and Round is in my case unique. I want to count the unique values of those two columns. The total here should be 5.

[Anonymous · Accepted solution]

Try 

Measure = COUNTROWS(DISTINCT('Table'[Round]))+COUNTROWS(DISTINCT('Table'[Season]))

[Ahmedx]

pls try this

m1 = COUNTROWS(DISTINCT(UNION (VALUES('table'[Product],VALUES('table'[Category])))

[SG-01]

That does not work unfortunately, for every value it returns 2 instead of 1...

[Ahmedx]

Share sample pbix file to help you.

[SG-01]

I can't... but I changed my post. If I use your measure I get not enough value back.