Forum Discussion
pxl754
1 year agoNew Member
Need help with calculating a average
Hi All, I'm trying simply to calculate: Sum of EXP_ALW / Sum of EXP_CLM in my power BI table. I can't seem to get a aggregate percentage value to show in the Percent_ALW column up in my Power BI table. If I just use a simple Divide formula : EXP_ALW / EXP_CLM , it gives me the correct percentage for each individual data entry, but Power BI shows each individual data entry BUT what I want is a aggregate average. So in the sample table below, I'd expect to see 80% for the first entry under Percent_ALW. How do I get PowerBI to show that?
pxl754 not sure if I understood but it would be something like this
% Measure = DIVIDE ( SUM ( Table[Col ALW] ), SUM ( Table[Col CLM] ) )