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.
5 Replies
- Daniel29195
Community Champion
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.
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 
v-sathmakuriCommunity Support
Hi Anonymous ,
Thank you for reaching out to Microsoft Fabric Community.
Could you please provide the sample data to provide the better resolution.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks & Regards,
Rekha,
CustomerSupportTeam.
- v-sathmakuri
Hi Anonymous ,
If the issue is still not resolved, please share a sample of your data so we can investigate further.
Also, may I ask if the issue has been resolved? If so, kindly mark the helpful response as the accepted solution. This helps other community members with similar questions find answers more quickly.
Thank you.
- v-sathmakuri
Hi Anonymous ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you!!
