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

    Thank you, but this not what i am expecting, measure should not be blank for prod_category/company.

     

    if prod-category/company slected individually then it show blank, in hierarchial struture it should populate the values.

    • V-lianl-msft's avatar
      V-lianl-msft
      Icon for Community Support rankCommunity Support
      4 years ago

      Hi Anonymous ,

       

      Try this measure:

      Measure 2 = IF(ISINSCOPE('Table'[product category]),IF(ISINSCOPE('Table'[company ]),SUM('Table'[Value]),BLANK()),BLANK())

       

       


      Best Regards,
      Liang
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.