Adding condition/criteria to remove blank datasets

[Anonymous]

Hello Power BI Community,

I have a situation where the data I have feeding to tables and multiple Donut Charts is being skewed based on blank data. This is causing a real headache because I am not sure how to fix. Currently, the data is being run by a measure such as the following: 

OTD Label = IF(OnTimeDelivery[DayDiff2] <= -5 , "Early", IF(AND(OnTimeDelivery[DayDiff2] >= -4, OnTimeDelivery[DayDiff2] <= 3), "On-Time", IF(OnTimeDelivery[DayDiff2] >= 4, "Late", "NV")))

What this is doing, as can be seen by the picture below, is causing even blank values to come up and counted as "On-Time" which is causing the data to become inaccurate. Is there a way to add a function to my current measure that does not count blank data? Thank you for all your help community. I will submit a picture below showing the problem. 

[mwegener · Accepted solution]

Hi @Anonymous ,

check out the "Diabolical Genius of SWITCH TRUE"

https://powerpivotpro.com/2015/03/the-diabolical-genius-of-switch-true/

OTD Label = 
SWITCH(
       TRUE(),
       ISBLANK(OnTimeDelivery[DayDiff2]), BLANK(),
       OnTimeDelivery[DayDiff2] <= -5   , "Early",
       OnTimeDelivery[DayDiff2] <=  3   , "On-Time",
       OnTimeDelivery[DayDiff2] >=  4   , "Late",
       "NV"
       )

[amitchandak]

@Anonymous , Try like

if(isblank(DayDiff2),blank(),IF(OnTimeDelivery[DayDiff2] <= -5 , "Early", IF(AND(OnTimeDelivery[DayDiff2] >= -4, OnTimeDelivery[DayDiff2] <= 3), "On-Time", IF(OnTimeDelivery[DayDiff2] >= 4, "Late", "NV"))))