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 !