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

Hi, 

I am not sure if I understood your issues, but from what I understood you want to show nulls on "1st level" of a matrix and when you drill down you would display values?

Like you suggested this can be achieved with ISFILTERED. Here is a fomula example:

Matrix with Blanks on lvl 1 = IF(
ISFILTERED('Matrix example'[Lvl 1])&&ISFILTERED('Matrix example'[Lvl 2])=FALSE(),"", //This checks if the current row is level 1 if so -> returns blank else returns the calculation below
SUM('Matrix example'[Value])) //Sum can be replaced with measure

End result:

The key here is to use multiple ISFILTERED functions with true and false conditions.

Hopefully this helps to solve your issue and if it does consider accepting this as a solution!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    this is what i am expecting..

     

    hope i am clear.

    • ValtteriN's avatar
      ValtteriN
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Okay, I think I got it now. Unfortunately, according to my understanding a single table and level 1 of a matrix operate the same way so it is not possible to have one showing nulls and the other showing values with the same formula. Maybe we should try a different approach? What is reason behind this measure so why do you need it?