Forum Discussion

Gheb_Gabriela's avatar
Gheb_Gabriela
Frequent Visitor
4 years ago

AVERAGE FORMULA

Hi all, I need help with something, if you have any idea:   I have used the below formula to make a measure for what I need in the report and it works for me, but is there any way to can add avera...
Need Help
Tips and Tricks
YalanWu_test's avatar
YalanWu_test
Icon for Helper I rankHelper I
4 years ago

Hi, Gheb_Gabriela ;

You could create a measure.

 measure=if(hasonevalue([Cate]),[PAYOUT MEASURE],AVERGEX('TABLE',[PAYOUT MEASURE])

 By HASONEVALUE, [Cate] should be the column in your matrix column field. 

If not right.Can you post sample data as text and expected output?

 

Best Regards,

  • Gheb_Gabriela's avatar
    Gheb_Gabriela
    Frequent Visitor
    4 years ago

    Hi YalanWu_test the formula is not working 

     

    Ok, so the my table in excel is looking like this 

    The formula used for this ones in excel was : 

    In Power BI I have done like this : Sum of the column i needed for my result and count of the same column. After that, to get the exact results from my Excel Table i have used the below formula and it is working perfect. I have the same results for the columns but not the average for totals. I need the average to work vertically or horizontally, doesn't matter. Below the formula from Power BI

    This are my results on matrix in Power BI. Also I think, maybe it is a problem because I can't replace blanks in the matrix to be 0.0%. I have tried with "+0", I have tried with count formula, nothing it's working.

    Thanks a lot, appreciate your time to answer.!