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.

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    mahsy , Try a measure like

    calculate(sum(Table[Value]), filter(allselected(Table), Table[AXE1] = max(Table[AXE1] ) && Table[AXE2] = max(Table[AXE2] ) ) )

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