Blanks in matrix needed

Question

Hi i have situation where my matrix is not allowing me to replace zero's instead of blanks .&nbsp;&nbsp;please check the below calculation and screenshot.&nbsp;&nbsp;DAX Calculation&nbsp; &nbsp; &nbsp; # Subjects = var sub = [Subjects]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;var coun = [Countries]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return IF(ISBLANK([Countries]),sub,IF(ISBLANK(sub),0,sub))&nbsp;&nbsp;Blank replacing with 0Regular count without zero

greg_deckler · Answer

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

chotu27 · Answer

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 · Answer

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 · Answer

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

v-jiascu-msft · Answer

Hi&nbsp;chotu27,&nbsp;Did you try to replace the 0 with BLANK() like&nbsp;this?# Subjects =
VAR sub = [Subjects]
VAR coun = [Countries]
RETURN
    IF ( ISBLANK ( [Countries] ), sub, IF ( ISBLANK ( sub ), BLANK(), sub ) )Best Regards,Dale

Forum Discussion

Blanks in matrix needed

5 Replies

Related content

Remove Blank Rows in Matrix

Replace blank with 0 in matrix visual

Need to Show Zero values in the blank Matrix

PowerBI - Matrix table blanks

Need help on matrix visual