Home

Power bi and Average

%3CLINGO-SUB%20id%3D%22lingo-sub-539317%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20bi%20and%20Average%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-539317%22%20slang%3D%22en-US%22%3EYou%20will%20need%20to%20use%20DAX%20to%20calculate%20the%20average%20of%20the%20entity.%20For%20example%20if%20the%20table%20is%20called%20flour%20and%20you%20have%20sales%20column%2C%3CBR%20%2F%3ETo%20calculate%20the%20sum%2C%3CBR%20%2F%3ESum%20%3D%20Calculate(Sum(flour%5Bsales%5D))%3CBR%20%2F%3EWhile%20the%20average%20will%20be%3CBR%20%2F%3E%3CBR%20%2F%3EAverage%20%3D%20Calculate(Average(flour%5Bsales%5D))%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-540854%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20bi%20and%20Average%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-540854%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F313611%22%20target%3D%22_blank%22%3E%40AKP_1%3C%2FA%3E%26nbsp%3B%2C%20CALCULATE%20is%20not%20necessary%20here%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-540880%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20bi%20and%20Average%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-540880%22%20slang%3D%22en-US%22%3EReally%3F%20I%20thought%20it%20is%20needed%20in%20the%20PowerBI%20environment.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-541168%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20bi%20and%20Average%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-541168%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F313611%22%20target%3D%22_blank%22%3E%40AKP_1%3C%2FA%3E%26nbsp%3B%2C%20if%20you%20use%20filters%20when%20with%20CALCULATE%2C%20otherwise%20why%20to%20complicate.%20Here%20is%20Excel%20data%20model%20environment%2C%20but%20in%20Power%20BI%20it's%20the%20same%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-541177%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20bi%20and%20Average%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-541177%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%20For%20the%20heads%20up!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-542917%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20bi%20and%20Average%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-542917%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F313611%22%20target%3D%22_blank%22%3E%40AKP_1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-458377%22%20slang%3D%22en-US%22%3EPower%20bi%20and%20Average%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-458377%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI've%20been%20using%20Pivot-tables%20where%20we%20can%20easily%20choose%20Average%2Csum%2C...%20(like%20the%20image%20below)%20-%20but%20is%20there%20something%20like%20that%20in%20Power%20bi%26nbsp%3B%20-%20I%20have%20values%20but%20I%20don't%20know%20how%20the%20find%20or%20display%20their%20AVERAGE%20in%20power%20Bi%20...%20would%20you%20please%20show%20me%20how%3F%26nbsp%3B%20%26nbsp%3B%20thank%20you%20in%20advance%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20431px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F109017i1248D054A84C1BD4%2Fimage-dimensions%2F431x309%3Fv%3D1.0%22%20width%3D%22431%22%20height%3D%22309%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-458377%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
ahmad ali
Contributor

Hello,

I've been using Pivot-tables where we can easily choose Average,sum,... (like the image below) - but is there something like that in Power bi  - I have values but I don't know how the find or display their AVERAGE in power Bi ... would you please show me how?    thank you in advance

Capture.PNG

 

6 Replies

You will need to use DAX to calculate the average of the entity. For example if the table is called flour and you have sales column,
To calculate the sum,
Sum = (Sum(flour[sales]))
While the average will be

Average = (Average(flour[sales]))

 

@ahmad ali 

@AKP_1 , CALCULATE is not necessary here

Really? I thought it is needed in the PowerBI environment.

@AKP_1 , if you use filters when with CALCULATE, otherwise why to complicate. Here is Excel data model environment, but in Power BI it's the same

Thank you @Sergei Baklan  For the heads up!

Thank you @AKP_1 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies