Forum Discussion
Calculated measure not summing in matrix correctly
Hi, can someone advise why this isn't summing correctly? I've tried ISINSCOPE as well but didn't work. This is the formula
Anonymous
try the following :
var ds =
addcolumns(
values(strategic_asse_class ) ,
"calc" ,
if( ... , abs ( ... ) , ... , abs(... )
)
return
sumx ( ds , [calc] )
the idea is that you need to iterate over the dimension in rows.
let me know if this helps.
Daniel29195
Community Champion
Community ChampionAnonymous
try the following :
var ds =
addcolumns(
values(strategic_asse_class ) ,
"calc" ,
if( ... , abs ( ... ) , ... , abs(... )
)
return
sumx ( ds , [calc] )
the idea is that you need to iterate over the dimension in rows.
let me know if this helps.