Avoid blanks or zero's to calculate running total with filter

[Anonymous]

Hello All,

I am trying to calculate running count of distinct employees who are choached and i am able to get the result with below query.

Coached = 
CALCULATE( DISTINCTCOUNT(TimeOffDailyFact[EmployeeName_ID]),
    FILTER(
        ALLSELECTED(TimeOffDailyFact),
        
        TimeOffDailyFact[Coached_NonCoached] = "Coached" &&
        TimeOffDailyFact[FirstDayOfMonth] <= MAX(TimeOffDailyFact[FirstDayOfMonth])))

The result is workes fine but when a perticular month has no Coached employees, then it returns as blank as below image.

Even if we have blank values, the prior value which is 10 should continue in this case.

Any help please.

Thanks,

Mohan V.

[v-kelly-msft]

Hi  @Anonymous ,

As tested here,it works fine:

You could try to create a new measure as below:

Coached_total=SUMX(FILTER( ALLSELECTED(TimeOffDailyFact),
        TimeOffDailyFact[FirstDayOfMonth] <= MAX(TimeOffDailyFact[FirstDayOfMonth])),[Coached])

Pls note that the column "FirstDayofMonth" is a date format column which can be compared with.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Fowmy]

@Anonymous 

You can turn off the Show Item with non-Data. 

[Anonymous]

Thanks for the reply @Fowmy.

I did tried that already, but nothing changed actually.

The values still shows the same.

[v-kelly-msft]

Hi  @Anonymous ,

Have you checked my reply?Is your issue solved now?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Fowmy]

@Anonymous 

Not sure how your model is formed, if you can share a sample power bi file with this scenario, it would great.