Forum Discussion
Summarization of values in Matrix Visual
Hi Erik_Hille
Please refer to the linked guides for dealing with problems with matrixes totals :
https://www.youtube.com/watch?v=dgwsk2fjWLchttps://www.youtube.com/watch?v=eoT-jPzV3Wk
https://blog.finance-bi.com/power-bi-totals-incorrect/
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Erik_Hille
You can use ISINSCOPE() function.
e.g You can create a measure
Measure=IF(ISINSCOPE(Table[Year&Month]),[MoM])
The result will like this
You can refer to the following link about the function
ISINSCOPE function (DAX) - DAX | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Erik_Hille
You can use ISINSCOPE() function.
e.g You can create a measure
Measure=IF(ISINSCOPE(Table[Year&Month]),[MoM])
The result will like this
You can refer to the following link about the function
ISINSCOPE function (DAX) - DAX | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.