Forum Discussion
apuype
4 years agoFrequent Visitor
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...
- 3 years ago
You have a couple of options. My preference is COALESCE but you can also add 0 to a measure that you supsect might return BLANK()
One slightly unrelated note:
IF (HASONEVALUE ( Dim_Date[SLUSAWeekNum] ), SUMX ( FILTER ( ALL ( Dim_Date ), Dim_Date[SLUSAWeekNum] = CurrentWeek && Dim_Date[SLUSAYearNum] = CurrentYear), [Order Count Dispatch User]), BLANK ())doesn't really need the "Else" statement as BLANK is implied.
v-henryk-mstf
Community Support
3 years agoHi apuype ,
Whether the advice given by lbendlin has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.
Looking forward to your feedback.
Best Regards,
Henry