Forum Discussion

mahsy's avatar
mahsy
Helper I
4 years ago
Solved

Hide empty column and replace null by zero in matrix

Hi, I need your help please !  Here is a diagram explaining my problem and the expected result.    Thank you for your help !
matrix-empty-column
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi mahsy ,

    Maybe the formula is not standardized enough, try this one:

    Measure =
CALCULATE (
    SUM ( 'Table'[Value] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[AXE1] = MAX ( 'Table'[AXE1] )
            && 'Table'[AXE2] = MAX ( 'Table'[AXE2] )
    )
)

    This can get the result by your sample.

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

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

mahsy's avatar
mahsy
Helper I
4 years ago

Hi, thank you for your response !

I get this error with your formula.

 

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi mahsy ,

Maybe the formula is not standardized enough, try this one:

Measure =
CALCULATE (
    SUM ( 'Table'[Value] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[AXE1] = MAX ( 'Table'[AXE1] )
            && 'Table'[AXE2] = MAX ( 'Table'[AXE2] )
    )
)

This can get the result by your sample.

I attach my sample below for reference.

 

Best Regards,
Community Support Team _ kalyj

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