Need Help in calculating count of suburb

[Anonymous]

Hi,

I have following row in source

Keyword	Search_Type	Search_Category	Suburbs	Bed Rooms	Date Inserted
Perth-region	Residential	For Sale	Aveley;Bailup;Ballajura	1,2,3	01/04/2019 15:04:01
Perth-region	Residential	For Sale	Aveley;Bailup	1,2	01/04/2019 17:01:05

I have converted following row to multiple rows

SEARCH_SID	Keyword	Search_Type	Search_Category	Suburb	BedRooms	Date Insert
1	Perth-region	Residential	For Sale	Aveley	1	1/04/2019 15:04
1	Perth-region	Residential	For Sale	Bailup	1	1/04/2019 15:04
1	Perth-region	Residential	For Sale	Ballajura	1	1/04/2019 15:04
1	Perth-region	Residential	For Sale	Aveley	2	1/04/2019 15:04
1	Perth-region	Residential	For Sale	Bailup	2	1/04/2019 15:04
1	Perth-region	Residential	For Sale	Ballajura	2	1/04/2019 15:04
1	Perth-region	Residential	For Sale	Aveley	3	1/04/2019 15:04
1	Perth-region	Residential	For Sale	Bailup	3	1/04/2019 15:04
1	Perth-region	Residential	For Sale	Ballajura	3	1/04/2019 15:04
2	Perth-region	Residential	For Sale	Aveley	1	1/04/2019 17:01
2	Perth-region	Residential	For Sale	Bailup	1	1/04/2019 17:01
2	Perth-region	Residential	For Sale	Aveley	2	1/04/2019 17:01
2	Perth-region	Residential	For Sale	Bailup	2	1/04/2019 17:01

Now, I need to get count of suburb searched for that day I should be getting 5 accounding to source data. I am getting 13 coz of split of data. If anyone have idea about how I can solve this issue it will be great help.

[PattemManohar · Accepted solution]

@Anonymous  Please try this as a New Measure.

Test300 = 
VAR _Table = SUMMARIZE(Test300DistinctCount,Test300DistinctCount[SEARCH_SID],"Count",DISTINCTCOUNT(Test300DistinctCount[Suburb]))
RETURN SUMX(_Table,[Count])

[Anonymous]

Perfect! This is what I was looking. Thank you!

[AkhilAshok]

Why not do a DISTINCTCOUNT?

Suburb Count = DISTINCTCOUNT(Table[Suburb])