Forum Discussion

pxl754's avatar
pxl754
New Member
1 year ago
Solved

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] ) )

1 Reply

  • pxl754 not sure if I understood but it would be something like this

     

    % Measure = 
    DIVIDE ( SUM ( Table[Col ALW] ), SUM ( Table[Col CLM] ) )