Forum Discussion
Solved
It's a matrix totalling problem!
Hello, There are many, many posts about the issues with getting matrix totals and subtotals to behave in the way you want, but I am too inexperienced a coder to be able to extrapolate from the e...
It wasn't an ISINSCOPE issue. I had to amend the way it was summing things in each of the individual measures. Once I had done that, the original coding for the main measure worked correctly.
Hi HM615 ,
I would look at using ISINSCOPE to determine what level of the heirarchy you are at:
https://learn.microsoft.com/en-us/dax/isinscope-function-dax
Thank you for this suggestion. I am still trying to work out how I incorporate this into my particular measure. Given that the elements that make up my MainResultRaw (below) are all individual measures, and not columns, would this still be the way to go?
VAR MainResultRaw =
factCap2026[UF Estimate Home]
+ factCap2026[CF Estimate Home]
+ factCap2026[Insurance Estimate Home]
+ factCap2026[NoResponse Estimate Home]
+ factCap2026[Awaiting Estimate Home]
+ factFutureReg[UGY01_futurereg HOME]
+ factDrl2025ChangeCourse[Home Change Course who reg]
+ [FY Progression Home]