Forum Discussion
Solved
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 Ethic...
Hi,
Try this measure
Measure 2 = SUMX(VALUES(Calendar[Date]),[Measure])
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 clear
Hi,
Try this measure
Measure 2 = SUMX(VALUES(Calendar[Date]),[Measure])
Thank you very much! it works!!!!
You are welcome.