How to Count Locations (with multiple maintenance jobs) as 1

[StevenHarrison]

Hi Guys - I have a list of maintenance jobs logged against properties with the following column headers:

Place Ref, Date Logged and Jobs count

What I need to count is the number of Place Ref displayed in the Place Ref column, there are duplicates, so in the screenshot above would count as 2 entries - definition of the problem is each location can have a number of jobs logged against it in a different period of time, so this needs to be counted, i.e. same place, 2 different months, so counted twice.

Any help much appreciated

[StevenHarrison]

Thanks Amit - that absolutely worked 😀.

My Date Logged was already in the right format, so the following did it:

Table Count of Void entities = countx(summarize('ALL Jobs Final Report','ALL Jobs Final Report'[PLACE REF],'ALL Jobs Final Report'[DATE LOGGED]),'ALL Jobs Final Report'[PLACE REF])

[amitchandak · Accepted solution]

@StevenHarrison , try like

a new column

date month = eomonth([Date logged],0)

and a new measure

measure = countx(summarize(Table, Table[Place ref], Table[Date Month]), [Place ref])

[StevenHarrison]

Thank you for the help, much appreciated.