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 .
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.
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..
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])
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
![ละลาย (LALALYE) - DAOU PITTAYA ต้าห์อู๋ พิทยา [OFFICIAL MV]](http://i.ytimg.com/vi/wo6r9TgausI/mqdefault.jpg)
This helped me so much to understand SUMMARIZE. I stuck for 2 days why the filter context does not work with my table.
Welcome
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 .
So that only it can give the total max as a grand total..??
@@balaroxx2700 if you not given sumx function u cannot able to filtering the data
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.
Not sure what is your question
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.
Thanks keep learning
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..
Not sure about your question
Hi sir ..from where can I download all your datasets for my practice?
Datasets will be a available in the description. Check for data source. If files doesn't not exist you can use previously video files.
Hi! Can we apply these solution to summarizecolumns? thanks!
Yes. Try it
Hi,
Can u pls make video on to combine addcolumns & filter with Summarize...
Not sure what was the relationship between this
Can we create the same summarize table in direct Query mode as well?
Check playlists of this channel and explore topics on the similar line requested by you.
great explanation. Thank you...
You are welcome!
this helped a lot - thanks!
Glad to hear it! Keep Learning
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])
Can’t help much on the query in comments.
Thanks sir. Can you please share a video on both summarize and addcolumns and differences b/w ..
Soon will make a video
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
Didn't understand your question.
@@AnalyticswithNags In card visual
Is that possible show
Min Discount Amount
With
Supplier name
Supplier with Minimum Discount =
VAR MinDiscount = [Minimum Discount]
RETURN
CONCATENATEX(
FILTER('YourTable', 'YourTable'[Discount] = MinDiscount),
'YourTable'[SupplierName],
", "
)
How to write condition like this in power bi 2> price< =5
Can u help me
Sure. Here is the condition. Price > 2 && price
Didn't get it. Need to watch again hahaa
sure watch from playlist beginning