SUMX Function in DAX

[@GoodlyChandeep]

I am sorry, in the end of the video, I erroneously multiply Data[Price] * Data[Price]. Whereas it should be Data[Price] * Data[Units]

[@Everyonelovesyou]

This is best explanation of Sumx by far, I am here for DAX for quite some time.

[@PriyankaMaggo-j5k]

Great videos, can you please share data for all dax videos?

[@lionels839]

Hi
How do you multiply columns form different tables or multiply a measure with a column?

[@vishaljhaveri7565]

Thank you, Chandeep! It was really an insightful video.

[@GoodlyChandeep]

Glad you liked it!

[@charithgowda_9961]

Bro love your explanation ❤️

[@GoodlyChandeep]

Glad to hear that!

[@ZAHIDHUSSAIN-ri5kg]

Many Thanks

[@vinodkumarhs4000]

Sumx giving wrong results when we having identical rows any solution for this problem

[@LotfyKozman]

Welcome back goodly man.

[@abhisheksarkar1515]

Please create a video on summarize

[@waynethurman2144]

Excellent! Mistake happens.

[@jupoi89]

Can an excel sheet (a calculator based on PMT formula) converted to some kind of secured software so that no one can check the formula used behind the final result?

[@GoodlyChandeep]

You can somewhat lock the spreadsheet. Please read this - www.goodly.co.in/protect-sheet-in-excel/

[@venkatareddykummitha5863]

Which one is best in terms of Performance/good calculations SUM OR SUMX?

[@juanisidrodiaz3093]

th-cam.com/video/NkYwwb7I3BY/w-d-xo.html check this video

[@Datazone12]

in terms of performance we can say that sum is better than sumx coz sumx iterates the result for each record and if the file size holds millions of rows it would give a bad performance experience on the other hand sum will aggregate values in one go just it wont be available for iterative calculation....I hope i am right in explaining this

[@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

[@GoodlyChandeep]

Try something like this
VAR Series = {5,7,2,3,9,10,2}
RETURN
TOPN(3, SUMMARIZE(Series,[Value]))

[@sebastian38093]

Traihard