Forum Discussion

chotu27's avatar
chotu27
Icon for Post Patron rankPost Patron
8 years ago

Blanks in matrix needed

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...
Need Help
Show and Tell
Tips and Tricks
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

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's avatar
chotu27
Icon for Post Patron rankPost Patron
8 years ago

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

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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