Forum Discussion
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
Hi,
Try this measure
Measure 2 = SUMX(VALUES(Calendar[Date]),[Measure])
5 Replies
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.
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 clearHi,
Try this measure
Measure 2 = SUMX(VALUES(Calendar[Date]),[Measure])
