Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

 

DAX

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    [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