Forum Discussion

Frequent Visitor

5 years ago

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...

Need Help

Anonymous
5 years ago
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.