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...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

values for company, category are not correct at higher level i mean when selected as single attribute in table, but when i drill down with brand then values are correct at that level, so aggregated values are not correct, which should be avioded , and we are using this power bI dataset as source to different dasbaords unlike sql server or azure etc.., so to aviod developers use wrong info we need to hide data at upper level.

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

In this case shouldn't a simple, 

IF(ISFILTERED('Matrix example'[Brand]),SUM('Matrix example'[Value]),"")
Do the trick? 
If the information is correct when filtered via brand then this condition should ensure the validity of data.

Example of how it looks:

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    can you share pbix with me, i tired similar method but its not working for me

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    how about if i have to drilldown by company and brand?

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