How to use SUM and SUMX in Power BI // Complete Beginners Guide to Power BI in 2020

[@learnenglishwithcumaali2883]

You did not explain the difference between SUM and SUMX???

[@mrjpwalkinson7495]

Never put your face in camera when explaining something

[@SolutionsAbroad]

Thanks for the feedback!

[@pthapa55]

😂😂😂

[@ปิยณัฐสัตย์จริง]

i think so.

[@giri41]

Test_1 =
var PriceperUnit_CY = DIVIDE([Sales_CY],[Quantity_CY],0)
var PriceperUnit_PY = DIVIDE([Sales_PY],[Quantity_PY],0)
var SalesVariance = [Sales_CY]-[Sales_PY]
return
SUMX(VALUES(ATC[material_style1]),if(DIVIDE([Sales_CY],[Quantity_CY],0)=0 || DIVIDE([Sales_PY],[Quantity_PY],0)=0,[Sales_CY]-[Sales_PY],1))

[@giri41]

please help. this is not working..
Test_1 =
var PriceperUnit_CY = DIVIDE([Sales_CY],[Quantity_CY],0)
var PriceperUnit_PY = DIVIDE([Sales_PY],[Quantity_PY],0)
var SalesVariance = [Sales_CY]-[Sales_PY]
return
SUMX(VALUES(ATC[material_style1]),if(DIVIDE([Sales_CY],[Quantity_CY],0)=0 || DIVIDE([Sales_PY],[Quantity_PY],0)=0,[Sales_CY]-[Sales_PY],1))

[@sebastiankachau7780]

How do you sum up the "Total Amount " column and display the figure at the bottom of the column?

[@giri41]

please help below code not working .. bypassing IF statement when i use in SUMX

[@nehasharma-jd9kc]

nice video but u should show your screen more closely, it really hard to see the formulas. ya one more thing, I m watching the playlist but I feel videos should be arranged according to topics means step by step not randomly

[@SolutionsAbroad]

That's great feedback thanks, I've fixed this issue in my recent videos, where i zoom in / out of the screen

[@BISAACk]

Hi, i tried the SUMX but when i added the new measure to the visual table it did not like it.
Total Avg = SUMX(MeasureTable, MeasureTable[Field01] + MeasureTable[Field03] + MeasureTable[Field03]) / 3
Basically i wanted to sum 3 columns and get the average total

[@-SairamR]

You can use the averagex function right

[@gilang6128]

please upload more videos especially common function DAX like count, sum, divide, filter, cumulative, if/switch

[@SolutionsAbroad]

Hi, thanks for watching! I already covered a lot of the functions you've mentioned, let me know if there's any specific function you want me to cover!

[@zauronasaurtv6240]

Thank you so much sir!

[@SolutionsAbroad]

You're welcome, thanks for watching!

[@shruthishree5785]

Good explanation.. Please upload more vedios on pwrbi dax

[@SolutionsAbroad]

More videos are coming buddy, thanks for watching!

[@TheBestBirdBomber]

Is there a way to fix the row totals when using SUM and IF conditions together?

[@antipghosh]

Sir, How to do summation of first 3 numbers in a series in power bi....?
Series: {5, 7, 2,3,9,10,2}
Desired sum: 5+7+2

[@giri41]

How to count customer hierarchy in customer table spending in each category in material table

[@policani]

Why the heck do I have to use Dax for this? In Excel, I just toggle my pivot tables between count and sum.

[@SolutionsAbroad]

Hi Cark, you can also do this by putting the values on a table, Power BI will calculate the sums for you. The point of using DAX is explicitly define what the calculation should do when someone else uses it

[@harshalpatil2111]

Thank god you are there... :)👍

[@kamrankhan-hh9jv]

i have been stuck somewhere total in correct in measure kindly solve this issue can i sent to my PBXfile

[@pthapa55]

what are you stuck on, send an example.

[@giri41]

Please continue making videos.. thanks

[@todayflower6367]

very nice video!

[@erwerwewerwer4575]

Legend!

[@LintuMan1004]

Nice 👍

[@ltsMeEvy2]

So does this mean I use SUM on a already existing colum, and SUMX to calculate data from a non existing colum, or does this logic not always apply? Thank you so much for the video!

[@SolutionsAbroad]

SUM and SUMX both use existing columns, either directly or through expressions,
The expressions could be more calculations but ultimately they always refer to a column in a table
I've never used SUM or SUMX other than this way, hope that helps!