cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## Grouping in Measure. Is it possible?

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

1 ACCEPTED SOLUTION
Super User

Hi,

Try this measure

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

Regards,
Ashish Mathur
http://www.ashishmathur.com
5 REPLIES 5
Super User

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.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Helper III

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

Super User

Hi,

Try this measure

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

Regards,
Ashish Mathur
http://www.ashishmathur.com
Helper III

Thank you very much! it works!!!!

Super User

You are welcome.

Regards,
Ashish Mathur
http://www.ashishmathur.com

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.