Blank Values

[pfarahani]

Hi Guys, I created this Calculated table, and it seems to work pretty good, how can I handle the blank? Bascially to say if its blank then to print the word blank. Thanks

[ryan_mayu]

@pfarahani 

maybe try add filter 

xxxxx

SUMMARZIE( FILTER('JBSIS PROBATE FULL REPORT', DEPTABBREVIATION<>""), XXXXX)

[pfarahani]

@Greg_Deckler Hi Greg, I am up against a deadline on this! Any hints, how to incorporate Blanks into this syntax thanks

[Greg_Deckler · Accepted solution]

@pfarahani Well, one way would be to incorporate the FILTER for removing the blank row from you CALCULATETABLE and do this:

Table =
  VAR __BlankTable = SELECTCOLUMNS( { ("Blank", "Blank", 1) },"DepartmentAbbreviation",[Value1], "CourtDept",[Value2],"Used",[Value3])
RETURN
  UNION(
    __BlankTable,
    <Your CALCULATETABLE with the FILTER for blank rows goes here>
  )