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

What is summarize function in DAX
Create a calculated table in DAX, Create a virtual table in DAX and Apply aggregation on top of that., how to find Sum of Max values in DAX, Power bi dax tutorial with examples

#powerbi #powerbidax #summarize

Complete Playlists

BI Developer - Complete Reference - Playlist
BI Architect - Complete Reference - Playlist

[hudzaifahhudzaifah-zvyw]

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

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

[sanjayanc]

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.

[poojamaurya]

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..

[ChandraShekar-dtsh]

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

[Lakshmi]

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

[Bloody_August]

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

[banasaikrishna]

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

[lawsonlutchman]

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 =
Management', 'Leave Management'[DateDiff] = 3
), "Leave 3 Day Category", 'Leave Management'[DateDiff]), [DateDiff])

[UniversalFacts-unknown]

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

[rajeshkhanna]

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

[umashankarverma]

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

[shafa]

Didn't get it. Need to watch again hahaa