USERELATIONSHIP & Convert BLANKS to 0
Hello All! Looking for some guidance on converting blanks to 0 within a measure that also uses the USERELATIONSHIP function. My regular ways do not seem to work with this. My "master measure" as I call it starts with the relationship function - this count keeps 0's as blanks but I require the 0. I use the master within the custom date period measures Order Count Dispatch User = CALCULATE ( DISTINCTCOUNT ( 'Executive_Reporting'[Order_Id] ), USERELATIONSHIP ( Executive_Reporting[dispatcher_user_id], 'Master - User ID'[User ID] )) To encorporate into our custom date periods I then move to this measure Order Count Dispatched By Current Week CY = VAR CurrentWeek = SELECTEDVALUE ( 'Dim_Date'[SLUSAWeekNum] ) VAR CurrentYear = SELECTEDVALUE ( 'Dim_Date'[SLUSAYearNum] ) RETURN IF (HASONEVALUE ( Dim_Date[SLUSAWeekNum] ), SUMX ( FILTER ( ALL ( Dim_Date ), Dim_Date[SLUSAWeekNum] = CurrentWeek && Dim_Date[SLUSAYearNum] = CurrentYear), [Order Count Dispatch User]), BLANK ()) You can see when brought into the table that the blanks then don't allow the calculations to work and show the proper change over prior week Any help would be appreciated!
