Measure to create totals by grouping within table

[dpmsvendor]

Hi, I need to create a measure that I will use to divide in another measure. The trick is to group one of the measures by quarter.

Here is how the data is set up. The start date has a relationship to a calendar table which has the quarter column:

Respondent ID	Start Date	Attribute.1	Value
a123	6/1/2022	color red	yes
a124	6/2/2022	color red	maybe yes
a125	6/3/2022	color red	neither yes or no
a126	6/4/2022	color red	maybe no
a127	6/5/2022	color red	no
a128	6/6/2022	color blue	yes
a129	6/7/2022	color blue	maybe yes
a130	6/8/2022	color blue	neither yes or no
a131	6/9/2022	color blue	maybe no
a132	6/10/2022	color blue	no

Here is what I'm trying to accomplish. The left table is what I have now, and the right table shows what I need:

Count Respondent ID, All and % are all measures.

• Count Respondent ID = CALCULATE(COUNT('table'[Respondent ID]))
• All = CALCULATE(COUNT('table'[Respondent ID]),ALLSELECTED('table'[Value]))
• % = DIVIDE('table'[Count Respondent ID], 'table'[All])

Would appreciate any help and advice. Thanks!

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[dpmsvendor]

Thanks Ashish! Worked perfectly

[Ashish_Mathur]

You are welcome.