Blanks in matrix needed

[chotu27]

Hi i have situation where my matrix is not allowing me to replace zero's instead of blanks .

please check the below calculation and screenshot.

DAX Calculation      # Subjects = var sub = [Subjects]
                                                     var coun = [Countries]
                                                      return IF(ISBLANK([Countries]),sub,IF(ISBLANK(sub),0,sub))

Blank replacing with 0Regular count without zero

[Greg_Deckler]

I'm not following this, seems like your screen shot shows blanks replaced by 0's

[chotu27]

@Greg_Decklerin a matrix if i even i replaced with Zero that countries which are not involved also showing zero . can i know the dax formulae for it to make it work.

[Greg_Deckler]

Going to need to see example source data. I have no idea what you have in your data for columns like Subject and Countries so difficult to tell you what is going on.

[chotu27]

@Greg_DecklerI just sent private message to you please acess the link. you can aslo check the calculation .

[v-jiascu-msft]

Hi @chotu27,

Did you try to replace the 0 with BLANK() like this?

# Subjects =
VAR sub = [Subjects]
VAR coun = [Countries]
RETURN
    IF ( ISBLANK ( [Countries] ), sub, IF ( ISBLANK ( sub ), BLANK(), sub ) )

Best Regards,

Dale