Forum Discussion
Matrix Table Undesired Value
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
2 Replies
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
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.
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.
