Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Show Nulls when attribute is selected and show values when selected in combination with other attrib

Hello,   how to show null when attribute is placed as single in table and to show values when placed in combination of other attributes in table.   for example: we have 3 columns in table stating...
ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

If the data is correct only with those two drilldowns in place then,

IF(and(ISFILTERED('Matrix example'[Brand]),ISFILTERED('Matrix example'[Company])),SUM('Matrix example'[Value]),"")

Should do the trick.

Then to get this to work in a matrix you can use Brand as a column and Company as  a row:

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks ValtteriN i tired this, but unfortunately my client wants it to have both in columns with filtering in both directions..

 

thank you so much..

thanks,

Geetha.