I’ve created a formula in excel : =SUMPRODUCT(AK14:AK37,AM14:AM37) that gives a result of 98.77%(converted to percentage). I tried using sumx function and it works only in when applied in a matrix(filter context) but not in the total.
Excel:

power BI:

Please help me 🙂 TIA !