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