Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Running Total by Group - Matrix Total

I am having issues with calculating a running total by group (sex) in a matrix. My table is an attendance sheet so I just need to calculate the running total of the number of rows (attendants) for ea...
Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    Anonymous ,

    Sorry, try this

    Running Total by Sex = 
CALCULATE(
	COUNTROWS('tbl1'),
	FILTER(
		ALLEXCEPT('tbl1', 'tbl1'[Sex]),
		'tbl1'[Date] <= MAX('tbl1'[Date]) 
	)
)

    Regards,
    Mariusz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi Anonymous 

Try the below.

 

Running Total by Sex = 
CALCULATE(
	COUNTROWS('tbl1'),
	FILTER(
		ALLEXCEPT('tbl1', 'tbl1'[Sex]),
		'tbl1'[Date] <= MAX('tbl1'[Date]) &&
	)
)


Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Mariusz ,

 

That worked!  Thanks!  

Running Total by Sex = 
CALCULATE(
	COUNTROWS('tbl1'),
	FILTER(
		ALLEXCEPT('tbl1', 'tbl1'[Sex]),
		'tbl1'[Date] <= MAX('tbl1'[Date])
	)
)

Anonymous : Thanks for your help.  Problem solved...