Hey Shashank, I am very much thankful for your guidance and especially your scenario based ques help me lot to gain more knowledge . I have been selected for Senior Data Analyst Position in MNC.
Did not exactly work for my dataset. I am using the Superstore data . Finally I used the following solution: SUMX( SUMMARIZE(Orders,Orders[Category],"Cat",[Total Orders]),[Cat]) These videos are very helpful for concept building.
Shashank i have a Question when i put these values in table visual i can see the right total i need to Practice this Concept Can you please help me to show Tables and how you made the Relationships basically i need same datasets and both the tables aws one and where you applied distinct count measure and next one where you picked categories kindly assist.
its informative .. but please can you more explain it like why did you use sumx which type of logic you use. how do you know that i will use that dax function like this ...
Hey Shashank, I am very much thankful for your guidance and especially your scenario based ques help me lot to gain more knowledge . I have been selected for Senior Data Analyst Position in MNC.
Many many Congratulations 🎉
Excellent applied today for real time problem
Glad to hear this 😊
Did not exactly work for my dataset. I am using the Superstore data . Finally I used the following solution: SUMX(
SUMMARIZE(Orders,Orders[Category],"Cat",[Total Orders]),[Cat])
These videos are very helpful for concept building.
Glad to hear this.
Thanks for the tip. Had been struggling with this one
Shashank i have a Question
when i put these values in table visual i can see the right total
i need to Practice this Concept
Can you please help me to show Tables and how you made the Relationships
basically i need same datasets and both the tables
aws one and where you applied distinct count measure and next one where you picked categories
kindly assist.
Please upload Dataset for this videos so we will understood properly??
its informative .. but please can you more explain it like why did you use sumx which type of logic you use. how do you know that i will use that dax function like this ...
Sure will keep in mind.
Btw practice more and the more you practice the more you will get the idea which function to use when.
Hello Sir, its giving Total not distinct count pls help
PcountV1 = if(HASONVALUE(Orders[Product Name]), [Pcount] , SUMX(Orders, [Pcount]))
Hey, bro ...Do you provide training/ coaching?
thanks a lot, your video really helped me solve my problem
Glad to hear this!
Awesome as always ❤ Thanks for such insightful videos😊
Welcome bhai 😊
But why total values shows incorrect in the given question
It happens sometimes..you will also face this in your real time projects..and that's what I have explained in the video..so plz watch it again.
Simple yet effective
Glad you think so!
Can you explain why the total was wrong in the first place? How did it get the wrong count of 25164?
Because the filter context was not traveling correctly to totals row..that's what I have explained in the video..plz watch it again
superb