Forum Discussion
Solved
Semi-Additive Calculations - Total Values wrong
Hi, here is what i am trying to accomplish: Target: Building a Liquidity Report, showing for each business area / company / account the values: Closing Balance, Overdraft, Liquidity, week-over-w...
Hi Bruin87 ,
Based on your description, maybe you could use ISINSCOPE() or HASONEVALUE() function to define your value of subtotals manually in the matrix visual.
Please refer to the following tutorials.
ISINSCOPE function (DAX) - DAX | Microsoft Docs
HASONEVALUE function (DAX) - DAX | Microsoft Docs
Customizing Hierarchy Measures in DAX using InScope - Visual BI Solutions
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Bruin87 , based on you columns in rows of matrix try new measure like
sumx(summarize(Table, Table[Column1], Table[Column2], Table[Column2], "_1", [KK]),[_1])