Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

MCF Mean cumulative function in Power BI

I have been trying to get this to work for weeks and finally found the courage to ask my fellow Power BI hustlers for help.   The theory is simple: The MCF cumulates the number of events (e.g. repa...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    For anyone interersted, I believe to have found a solution to my problem.

     

    No maschines =
CALCULATE (
    DISTINCTCOUNT ( data[Maschine number] ),
    data[Time of failure] >= MAX ( data[Time of failure] )
)

     

    Step_Size = DISTINCTCOUNT(data[repair_id]) / [No machines]

     

    MCF = 
SUMX(
	FILTER(
		ALLSELECTED(data[Time of failure]),
		data[Time of failure] <= MAX ( data[Time of failure] )
	),
    [Step_Size]
)
ZvikaBK2801's avatar
ZvikaBK2801
Regular Visitor
1 year ago

Hi, 

Your solution is nice but cannot proprly handle a realistic situation in which the time to event include system censoring events as well as incomplete recurrent data with right censoring events. I have complete solution to both, as well as other realistic techenical issues. BTW, what about calculating confidence intervals around MCF? Let me know if you are interested.