Cumulative Total with Multiple Slicers & Categories

[krixtsup3r]

Hi,

I have a dataset below that I need to create a Cumulative Total & Cumulative %. I was able to create the cumulative but only with Error name.

I want to create a table that is dynamic enough for me to add/remove columns or use a slicer to control it. See Screenshot below on how I want it to look like:

Date	Employee	Error Name	Error Count
7/1/2020	Erick	Miss Guide	10
7/1/2020	Erick	Miss Guide	5
7/1/2020	Leonard	Out of box	9
7/2/2020	Leonard	Out of box	5
7/2/2020	Thomas	Turnover	5
7/2/2020	Erick	Turnover	8
7/3/2020	Leonard	Miss Guide	7
7/3/2020	Erick	Miss Guide	10
7/3/2020	Thomas	Retail	3
7/4/2020	Bryan	Rose	1
7/4/2020	Erick	Miss Guide	6
7/4/2020	Leonard	Out of box	3

[amitchandak]

@krixtsup3r , How it is 24 and 33 on 7/1/2020 ?

[krixtsup3r]

@amitchandak  is it not possible to that way?

[amitchandak]

@krixtsup3r , you need to tell logic to see if it is possible.

[krixtsup3r]

I just need to have something like this (screenshot below) with 3 slicers:

[dax · Accepted solution]

Hi @krixtsup3r , 

You could refer to my sample for details.

Best Regards,
Zoe Zhi

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