Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Dimensionality in Custom Columns

 

Hello All,

 

How do I accomplish the "Count_Total" column as show below?

 

------------------------------------------
Question |  Answers  | Count | Count_Total
------------------------------------------  
A        |  LOW      |     2 |          14         
A        |  MID	     |	   7 |          14
A	 |  HI       |     5 |          14
B        |  LOW      |     0 |          17
B        |  MID	     |    11 |          17
B	 |  HI       |	   6 |          17

 

To elaborate, the Count_Total column is what I desire, as shown above.  It should be a custom column (measure) that is the total count of all Answers, grouped/sliced by the elements of the Question dimension.

 

Can someone show me a DAX formula that will help me accomplish this?

 

Best regards,

Ronald

 

1 REPLY 1
Anonymous
Not applicable

[Count_Total] = -- this is a calculated column, not a measure
var __currentQuestion = T[Question]
var __countTotal =
	SUMX(
		filter(
			T,
			T[Question] = __currentQuestion
		),
		T[Count]
	)
return
	__countTotal

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.