Count Distinct but repeating rows due to report being monthly

[samjr]

Hey all,

Thank you in advance for the help.

The report I have is shown below (example at a very basic level. 231 total rows, 18 columns). How do I do a distinct count on this?

Resource	Resource title	date
john smith	teacher	7/1/2022
jojo rose	student	7/1/2022
john smith	teacher	8/1/2022

the result I want based on the table is 2. (1 John Smith and 1 Jojo Rose)

[parry2k]

@samjr your question is not fully clear. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[samjr]

did my edit help clear it up?

[v-easonf-msft · Accepted solution]

Hi, @samjr 

You can add a calculated table like:

Table 2 = DISTINCT( ALLEXCEPT('Table','Table'[date]))

Then add a measure to count the table rows:

Count=COUNTROWS('Table 2')

Best Regards,
Community Support Team _ Eason