Calculated measure not summing in matrix correctly

[dkdirenzo]

Hi, can someone advise why this isn't summing correctly? I've tried ISINSCOPE as well but didn't work. This is the formula 

[v-sathmakuri]

Hi @dkdirenzo ,

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

[v-sathmakuri]

Hi @dkdirenzo ,

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 @dkdirenzo ,

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.

[lbendlin]

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-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Daniel29195 · Accepted solution]

@dkdirenzo 

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.