Power BI DAX Tutorial (22/50) - What is Summarize function in DAX | Group By in DAX

[@hudzaifahhudzaifah-zv6yw]

This helped me so much to understand SUMMARIZE. I stuck for 2 days why the filter context does not work with my table.

[@AnalyticswithNags]

Welcome

[@balaroxx2700]

I am not able understand the summarize function bro can u explain it to me Summarize of table and we given the product name column so that it is going to display it in the new table right and we given a column for maxqts(measure) so it go display it also right .then why we are giving the max of sales quantity again when we have the maxqty (measure) already .

[@balaroxx2700]

So that only it can give the total max as a grand total..??

[@sanjayanc1442]

Hi. You might want to make another video on summarize fxn. The explanation is not as clear as other functions/videos. You are doing a great job btw.

[@AnalyticswithNags]

Thanks keep learning

[@pranavindi7152]

great explanation. Thank you...

[@AnalyticswithNags]

You are welcome!

[@ebogart42]

this helped a lot - thanks!

[@AnalyticswithNags]

Glad to hear it! Keep Learning

[@ChandraShekar-dt2sh]

Hi, Can u pls make video on to combine addcolumns & filter with Summarize...

[@AnalyticswithNags]

Not sure what was the relationship between this

[@Yaks_TV]

Hi, what if want to count those Product name with only MaxQnty = 3. . . I want to have it on Card Visualizations and reflect it. which in your example should result to 3 (Jeans Denim, Jeans Levis, and Jeans Zara, total of 3 in Card). What is DAX measure/formula? Thanks.

[@AnalyticswithNags]

Not sure what is your question

[@Lakshmi1010]

Hi sir ..from where can I download all your datasets for my practice?

[@AnalyticswithNags]

Datasets will be a available in the description. Check for data source. If files doesn't not exist you can use previously video files.

[@Bloody_August]

Hi! Can we apply these solution to summarizecolumns? thanks!

[@AnalyticswithNags]

Yes. Try it

[@banasaikrishna420]

Can we create the same summarize table in direct Query mode as well?

[@AnalyticswithNags]

Check playlists of this channel and explore topics on the similar line requested by you.

[@poojamaurya5715]

Hello.. I have a table contains columns comments and differtn month,i want to group the comments month wise..i am using group by..but its only applicable for single month ,when i am using same Group by dax with other column name its Showing error. A table of multiple values was supplied,plz suggest wht should be done..

[@AnalyticswithNags]

Not sure about your question

[@UniversalFacts-unknown]

Thanks sir. Can you please share a video on both summarize and addcolumns and differences b/w ..

[@AnalyticswithNags]

Soon will make a video

[@lawsonlutchman6921]

Hi NAGS, wonderful video, I am trying to achieve the following summarized result, I have a measure that calculates the difference between 2 dates, another measure that categorizes the date differences as 1 Day, 2 Day and 3 Days and more. I need to count the occurrences of the day categories. I cannot create tables or columns as the source is a cube. I have tried.. 3DayCount = COUNTX(Summarize(FILTER('Leave Management','Leave Management'[DateDiff] = 3 ),"Leave 3 Day Category",'Leave Management'[DateDiff]),[DateDiff])

[@AnalyticswithNags]

Can’t help much on the query in comments.

[@rajeshkhanna8709]

Hi I Have question that Min Or Max In table haveing highest Discount or lowest Discount Which supplier have min Discount I want ans like below Mohammed 1 I want ans Min Discount and Supplier name That into CARD Visual When we display same ans on card visual ans should be asc

[@AnalyticswithNags]

Didn't understand your question.

[@rajeshkhanna8709]

@@AnalyticswithNags In card visual Is that possible show Min Discount Amount With Supplier name

[@littlesplendidkids2814]

Supplier with Minimum Discount = VAR MinDiscount = [Minimum Discount] RETURN CONCATENATEX( FILTER('YourTable', 'YourTable'[Discount] = MinDiscount), 'YourTable'[SupplierName], ", " )

[@shafa7668]

Didn't get it. Need to watch again hahaa

[@AnalyticswithNags]

sure watch from playlist beginning

[@umashankarverma3179]

How to write condition like this in power bi 2> price< =5

[@umashankarverma3179]

Can u help me

[@AnalyticswithNags]

Sure. Here is the condition. Price > 2 && price