calculate unique new countries countries, sites, departments from last 3 months not present earlier

[Anonymous]

Hi Guys,

I have a table like this

Country	site	Department	total views	Date activation
India	a	a1	20	01/01/2021
Australia	b	a2	30	23/10/2015
NZ	c	b1	10	15/12/2021
India	a	b2	10	03/03/2018
Canada	a	c1	20	04/03/2018
Australia	z	a1	30	15/08/2022

I need unique counts of country, department and site, along with total view upto date and last 3 months from today

	unique country	Unique site	unique departmet	views
All	4	5	3	90
Last 3 Months	1	1	0	30

Can you help me with dax measure

[Greg_Deckler · Accepted solution]

@Anonymous These are all variations on a theme involving COUNTROWS, DISTINCT and SELECTCOLUMNS with maybe a FILTER and EOMONTH thrown in for your last 3 months:

Unique countries = COUNTROWS(DISTINCT('Table5'[Country]))

Unique sites = COUNTROWS(DISTINCT(SELECTCOLUMNS('Table5',"Country",[Country],"Site",[site])))