Grouping in Measure. Is it possible?

[vika160]

Hello all,

I need a help to figure out how to build a measure with grouping if this possible.

Exam_date	Examinees	module	sessionID
6/10/2022	21	Accident	62
6/10/2022	23	Ethics	68
6/10/2022	34	Life Insurance	51
6/10/2022	28	Segregated funds	64
6/23/2022	1	Accident	62
6/23/2022	1	Ethics	68
6/23/2022	3	Life Insurance	51
6/23/2022	1	Segregated funds	64
6/10/2022	5	Accident	62
6/10/2022	3	Ethics	68
6/10/2022	2	Life Insurance	51
6/10/2022	2	Segregated funds	64
6/23/2022	32	Accident	62
6/23/2022	28	Ethics	68
6/23/2022	34	Life	51
6/23/2022	28	Segregated funds	64

What I need is 2 measures :

1. Calculates total number of examinees - done
2. Calculates Sum of (total of Uniq session per every date )  per any date frame   

Column SessionID is set to Count(Distinct) but - it counts distinct sessions in general. 

I need to calculate unique session by exam_date.

 for this date range totals unique sessions would be 8 as there are 4 unique sessions for Jun 10 and 4 for Jun 23.
I was trying to use group by but I was not successful.

And I need to hold Module field as it will be used in visual to slice by

Any help would be appreciated.

Thank you very much

[Ashish_Mathur]

Hi,

You may download my PBI file from here.  The total should be 4 (Not 😎 because there are 4 unique sessions id across both dates - 51, 62, 64 and 68.

Hope this helps.

[vika160]

It is not what I am looking for. I nedd total of Uniques sessions per date selection. I specified it in description. 
Total should be 8 for all this data set as there are 2 dates with 4 unique sessions per date.
I will update my desc if it is not very clear

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

Measure 2 = SUMX(VALUES(Calendar[Date]),[Measure])

[vika160]

Thank you very much! it works!!!!

[Ashish_Mathur]

You are welcome.