topic Hide empty column and replace null by zero in matrix in DAX Commands and Tips

Hide empty column and replace null by zero in matrix

mahsy — Fri, 04 Feb 2022 10:04:11 GMT

Hi,

I need your help please !

Here is a diagram explaining my problem and the expected result.

Thank you for your help !

Re: Hide empty column and replace null by zero in matrix

amitchandak — Fri, 04 Feb 2022 13:41:12 GMT

mahsy , Try a measure like

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

Re: Hide empty column and replace null by zero in matrix

mahsy — Fri, 04 Feb 2022 17:16:53 GMT

Hi, thank you for your response !

I get this error with your formula.

Re: Hide empty column and replace null by zero in matrix

v-yanjiang-msft — Thu, 10 Feb 2022 03:21:34 GMT

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.