Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Hide Blanks Values in Matrix - Hierarchy

Hi all,    I want to hid the blank values. I use this metric:  blanks = IF(MAX('Performance Indicator Hierarchy'[Performance Indicator Hierarchy Level 5 Name])<>BLANK(),1) and put it in the visua...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous 

    You may try to create a measure to get the correct total value.For example:

    Measure = 
IF (
    HASONEVALUE ( Table3[Column2] )
        && MAX ( Table3[Column2] ) <> BLANK (),
    SUM ( Table3[Value] ),
    CALCULATE ( SUM ( Table3[Value] ), ALL ( Table3[Column2] ) )
)

    Regards,

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous 

 

You may try below measure:

blanks =
IF (
    MAX ( 'Performance Indicator Hierarchy'[Performance Indicator Hierarchy Level 5 Name] )
        <> BLANK ()
        && MAX ( 'Performance Indicator Hierarchy'[Performance Indicator Hierarchy Level 6 Name] )
            <> BLANK ()
        && MAX ( 'Performance Indicator Hierarchy'[Performance Indicator Hierarchy Level 7 Name] )
            <> BLANK (),
    1
)

Regards,

Cherie

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi v-cherch-msft 

    Thanks for your solution, it's works but there are fields of certain levels of the hierarchy that disappear me :\. 

    Once again, thanks! 

    • v-cherch-msft's avatar
      v-cherch-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      Hi Anonymous 

       

      Could you explain more about your expected output?I cannot fully understand it.

      blanks =
IF (
    MAX ( 'Performance Indicator Hierarchy'[Performance Indicator Hierarchy Level 5 Name] )
        <> BLANK ()
        || MAX ( 'Performance Indicator Hierarchy'[Performance Indicator Hierarchy Level 6 Name] )
            <> BLANK ()
        || MAX ( 'Performance Indicator Hierarchy'[Performance Indicator Hierarchy Level 7 Name] )
            <> BLANK (),
    1
)

      Regards,

      Cherie

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi v-cherch-msft ,

        It's a flattened hierarchy, for example without measure I get this: 


        but when I put the measure I get this:


        The values ​​change, and brand marketing, for example, also disappears.

        If you need more information, please tell me and thank you very much to try help me.

        Kind regards.