Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
pfarahani
Helper II
Helper II

Blank Values

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

 

pfarahani_1-1628190325398.png

 

 

1 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>
  )

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
ryan_mayu
Super User
Super User

@pfarahani 

maybe try add filter 

xxxxx

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





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

Proud to be a Super User!




pfarahani
Helper II
Helper II

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

@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>
  )

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.