cumulative count of counted text in a column

[Anonymous]

I would appreciate if you could assist me in the following.

I need a simple DAX for running the sum of counts of a column that contains the text.

I need to count, for instance, "Medium" from a column titled Level and then create a running sum of the counts. The expected visual counts by month for various years as a bar chart and as a line cumulative of counts by month.

I hope you would be able to help.

Thanks,

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[Greg_Deckler]

So a running total is generally constructed along the lines of

Measure =

  VAR __Date = MAX('Table[Date])

  COUNTROWS(

    FILTER('Table',[Level] = "Medium" && 'Table'[Date] <= __Date)

  )

Column would be:

Column =

  VAR __Date = [Date]

  COUNTROWS(

    FILTER('Table',[Level] = "Medium" && 'Table'[Date] <= __Date)

  )

But sample data would help to make sure. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Thanks Greg

Unfortunately still struggling........

not sure about "  __Date)"   what this underscore line refers to? and "'Table'[Date] " here the date column is from the same table,

Can you pls one more assist, thanks

Following is the sample of data, again,

ID	Year	level	Date
114190002400	2019	Medium	9/7/2019
114190002420	2019	serious	9/10/2019
114190002440	2019	Medium	9/14/2019
114190002440	2019	light	9/14/2019
114190002460	2019	Medium	9/17/2019
115190000260	2019	light	9/24/2019
114190002461	2019	Medium	9/17/2019
114190002480	2019	Medium	9/19/2019
116190004480	2019	Medium	6/7/2019
116190004480	2019	Medium	6/7/2019
116190004480	2019	Medium	6/7/2019
116190004480	2019	Medium	6/7/2019
116190004480	2019	Medium	6/7/2019
116190004480	2019	light	6/7/2019
116190004480	2019	Medium	6/7/2019
116190004480	2019	Medium	6/7/2019
116190004481	2019	Medium	6/8/2019
116180001881	2018	Medium	3/19/2018
116180001881	2018	Medium	3/19/2018
116180001881	2018	Medium	3/19/2018
116180001881	2018	death	3/19/2018
116180001881	2018	Medium	3/19/2018
115180000320	2018	Medium	3/21/2018
116180001920	2018	light	3/20/2018
116180001940	2018	Medium	3/21/2018
116180001980	2018	death	3/21/2018
116180001980	2018	Medium	3/21/2018
101180000080	2018	light	3/16/2018
101180000080	2018	light	3/16/2018
116180001961	2018	Medium	3/21/2018
114180000800	2018	Medium	3/22/2018
116180001960	2018	Medium	3/21/2018
116180001981	2018	light	3/21/2018
116180001982	2018	Medium	3/21/2018
116180001983	2018	serious	3/21/2018
114180000780	2018	Medium	3/20/2018
114180000920	2018	Medium	4/12/2018
116180002240	2018	Medium	4/12/2018
201180001080	2018	Medium	4/13/2018
112180000400	2018	light	4/12/2018
112180000400	2018	Medium	4/12/2018
302180000080	2018	death	3/20/2018
302180000080	2018	serious	3/20/2018
302180000080	2018	death	3/20/2018

[Anonymous]

Hi

I tried the following  

measure 2 =

countrows(Filter( (data), data[level]="Death" && data[Date] <= MAX (data[Date]))

)

The above seems ok but not sure the error from following: too fee arguments are passed through filters.......

Column =

Countrows (FILTER(data), data[level]="death" && data[Date] <= MAX (data[Date])

)

please assist. 

[mahoneypat]

You should delete the parentheses around data in your Filter.

Regards,

Pat