Awesome video......I've gained so much from your videos and always look forward to your next challenge or tutorial. Thank you for all the valuable content. I have a question: I’m having trouble hiding the second column, 'Prod Name,' and every time I try, the height of the other columns keeps increasing. I’d really appreciate your help with this. God bless you!
I want to practice what you showed inn the video. But i do not have such data. Can you please give me the data also? Amazing video, beautifully taught by each part. Thank you!!!
was a wonderful video and it came in the right time I was thinking on the pareto visual. Howver I have an issue - RT Split = SWITCH( true(), value(SELECTEDVALUE('Split category table'[Value])="A+" & [Running contribution]
I have faced a problem. i have sales qty column in multiple table. sum all tables sales qty colum as well as sales target qty. and made another measure sales qty / sales target qty. all tables has division product wise 4 years sales data. now i want to count how much product sales ach% is greater than 100% for division? can you help me?
Agin one of 👍👍TOP PRESENTATION 👍👍, we have two parts A+ and others, what if I want to create more groups with some condions, group A should have top 80% of sales, group B have at top of 50% and C top 30% and the others. Or some another percentage A=90%, B= 70%, C=40%, D=10%,and other, It would be nice as one additional video. TOP
📌Learn DAX & Data Modelling - goodly.co.in/learn-dax-powerbi/
⬇Download the Power BI file - goodly.co.in/pareto-analysis-in-power-bi
This is amazing - so much content in half an hour. Thank you!
Thanks for sharing this video with us. It was really easy to follow along and have helpful as always.
Excellent 🎉... thanks for sharing
great video ,my question is must i create a calculate group . can i just create a measure instead of a calculated group
It's perfect. I have learned a lot about your knowledge as well as your logical reasoning step by step. Thank you very much.
ما شاء الله عليك استاذنا الفاضل ❤
Thanks for the wonderful tutorial. I have learned a lot.
I need the color value used in the final chart 😊
Very insightful & useful - thank you Chandeep!
Absolutely wonderful pure golden tutorial. Cool formulas, amazing examples and outstanding presentation 🎉❤
Thanks for sharing !!! l learned a lot from your video.
So amazing, thanks Chandeep!!!
Awesome video......I've gained so much from your videos and always look forward to your next challenge or tutorial. Thank you for all the valuable content. I have a question: I’m having trouble hiding the second column, 'Prod Name,' and every time I try, the height of the other columns keeps increasing. I’d really appreciate your help with this. God bless you!
Very insightful visual. I am gonna add this to my next project fs.
Truly amazing vid, really!
Again a great education
Hii do you provide the course in emi options?
Unfortunately we dont have that option now
can we apply this in matrix as well?
Nice work. I don't get the cross joined table though. Seems to work just fine with a two row table of the two categories and no relationship.
So elegant
Thanks
excellent.....Thanks for teaching👍👍👍
I want to practice what you showed inn the video. But i do not have such data. Can you please give me the data also? Amazing video, beautifully taught by each part. Thank you!!!
Hi sir do we have any EMI options for your course?
sorry not as of yet
Anybody knows what is the app he is using to draw/annotate in his screen?
was a wonderful video and it came in the right time I was thinking on the pareto visual. Howver I have an issue - RT Split = SWITCH(
true(),
value(SELECTEDVALUE('Split category table'[Value])="A+" & [Running contribution]
Use && instead of &
how can I make one of this and for example I have three table and I want whatever filter or percentage I choose the result changes in all 3?
Awesome!!
Great!
Will have to watch this first thing in the morning 😂😅😊🙏🏻🙏🏻
Thnx 4 ur effort, please build up your file with us step by step ..i belive that u need to accelerate your video but build with us
why I don't see the calculated groups feature in my PBI?
update it
@@GoodlyChandeepeven I don't see the calculation group native to my power bi inspite of updating it to latest October 2024 version
When I replace the product name with split category [prod name], the total sales became total amount across all the products. Where did I go wrong?
impressive
I have faced a problem. i have sales qty column in multiple table. sum all tables sales qty colum as well as sales target qty. and made another measure sales qty / sales target qty. all tables has division product wise 4 years sales data. now i want to count how much product sales ach% is greater than 100% for division? can you help me?
First like and comment is mine.😁
Agin one of 👍👍TOP PRESENTATION 👍👍, we have two parts A+ and others, what if I want to create more groups with some condions, group A should have top 80% of sales, group B have at top of 50% and C top 30% and the others. Or some another percentage A=90%, B= 70%, C=40%, D=10%,and other, It would be nice as one additional video. TOP
IT IS GIVING ME ISSUE OF RESOURCES EXCEEDES EVEN THOUGH IF I filter?
Same here
this is a lot of work and overhead for a simple view that can be done using SQL
Very very insightful🫡
Sundar IS FROM iit Kanpur
its Not working
Prod Name =
IF([Total Sales] && ISINSCOPE('Splite Category'[Prod Name]),SELECTEDVALUE('Splite Category'[Prod Name]),
VAR Tble = FILTER(ADDCOLUMNS(SUMMARIZE('Splite Category','Splite Category'[Prod Name],'Splite Category'[Value]),"Test",
VAR RT =CALCULATE(DIVIDE([Total Sales],CALCULATE([Total Sales],ALL('Splite Category'[Prod Name]))),
WINDOW(1,ABS,0,REL,ALL('Splite Category'[Prod Name]),ORDERBY([Total Sales],DESC)))
VAR TH =[Set Threshold]
RETURN
RT