Count ongoing values for this year and before

[MickeLearnPBI]

I have created a column that brings up the number of ongoing cases, using True (which is the Ongoing column)

Measurement value
= COUNTAX(ALLSELECTED(Cases), [Ongoing]) +0

When I use my slicer, it only looks at, for example, the year 2023, but I want it to also include previous years' ongoing cases. For example, the case may have started on 2022-12-31, and then it may still be ongoing and should be included in future counts.

I am a little lost right now and hope for assistance in this.

[xifeng_L]

Hi @MickeLearnPBI 

Since you didn't provide example data, I can only give a rough result, just for reference.

Measure = COUNTAX(FILTER(ALL(Cases),Case[Date]<=MAX(Slicer[Date])),[Ongoing])

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

[MickeLearnPBI]

Can I add a file here?

[xifeng_L]

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

[MickeLearnPBI]

Thx!
Here is the sample file.
Cases - Power BI 

[xifeng_L · Accepted solution]

@MickeLearnPBI 

You can try below two measurre.

Ongoing cases = CALCULATE(COUNT('Executions'[ExecutionID]),'Calender'[Date]<=MAX('Calender'[Date]),'Executions'[Ongoing case]="TRUE")



Ongoing cases 2 = COUNTAX(FILTER(ALL(Executions),Executions[ExecutionStartDate]<=MAX(Calender[Date])),[Ongoing case])

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

[MickeLearnPBI]

Great! That worked!
One last question:
Can the result be adjusted according to another slicer that I have belonging to the same table (Executions) with column (TypeOfCase).

The dax form I use today is

COUNTAX(ALL(Executions), [Ongoing case]) +0

[xifeng_L]

Since the ALL function ignores any filters, it needs to be contextualized to decide on a solution