Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Only Display Outer Measure in Matrix Row Hierarchy

I am creating a matrix that includes a row hierarchy. I'll call the two subcateories Category1 and Category2. The total member count for each subcategory should be the same. However, I would only like to display one of the values since it looks quite repetitive. I don't want the value to be aligned with either Category1 or Category2, but I would like it to be displayed aligned with the outer-measure, Year. Here is what it looks like when I expand the hierarchy. Any tips?

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    Please have a check this way.

     

    Measure 2 = 
IF (
    ISINSCOPE ( 'Table'[category] ),
    BLANK (),
    DIVIDE (
        CALCULATE ( SUM ( 'Table'[Member count] ) ),
        DISTINCTCOUNT ( 'Table'[category] )
    )
)

     

1 Reply

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Anonymous ,

     

    Please have a check this way.

     

    Measure 2 = 
IF (
    ISINSCOPE ( 'Table'[category] ),
    BLANK (),
    DIVIDE (
        CALCULATE ( SUM ( 'Table'[Member count] ) ),
        DISTINCTCOUNT ( 'Table'[category] )
    )
)