Matrix Table Undesired Value

[burakkaragoz]

Hello,
I want to see the value of subgroups as zero in the Total_Doviz_Deger column.
But I couldn't find what kind of dax code I need to write.

I would be very grateful if you can help.

translation and formatting supported by AI

[Anonymous]

Hi @burakkaragoz ,

In addition to using the ISINSCOPE function, you can also try the HASONEVALUE function. Also, if you don't want to show totals, turning off totals is also a way to do it.

theexcelclub.com

Best Regards,

Stephen Tao

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

[Syndicate_Admin]

you must identify which level of the matrix you are at at the time of performing the DAX calculation.

To do this, you can use the IsInScope(column) function

You can find details of the feature here: ISINSCOPE Function (DAX) - DAX | Microsoft Learn