Forum Discussion
MickeLearnPBI
Helper I
Helper ICount ongoing values for this year and before
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 ...
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~
MickeLearnPBIHelper I
Helper ICan I add a file here?
xifeng_L
Super User
Super UserIf 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-Forum/ba-p/963216
- MickeLearnPBI
Thx!
Here is the sample file.
Cases - Power BI- xifeng_L
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 isCOUNTAX(ALL(Executions), [Ongoing case]) +0