How to FIX Incorrect Measure Totals in Power BI ?? | Power BI Interview

Codebasics Data Analyst Bootcamp Link: codebasics.io/...
Topmate Link to book call 1:1 - topmate.io/lea...
Link for the Scenario based QnA in Power BI: • Scenario based QnA - P...
Link for the Power Bi Interview QnA playlist :
• Power BI Interview QnA
Link for the SQL QnA playlist :
• SQL Interview QnA for ...
Link for the Data Warehousing QnA playlist :
• DW Concepts Based QnA
Your queries:
power bi interview questions
power bi interview questions and answers
power bi interview
power bi interview questions for experienced professionals
power bi interview questions for freshers
deloitte power bi interview questions
power bi scenario based interview questions
power bi service interview questions
scenario based power bi interview questions
power bi practice scenarios
power bi real time scenarios
shashank singh power bi
power bi scenario based questions
sql and power bi interview questions
capgemini power bi interview questions
accenture power bi interview questions
power bi managerial round interview questions
how to explain project in power bi interview
power bi roadmap
power bi jobs for freshers
power bi project explanation in interview
power bi resume for freshers
power bi fresher jobs
power bi resume
power bi developer resume
power bi resume for 2 years experience india
power bi developer resume for experienced
#powerbiinterview
#learnwidgiggs

[@nikhilkurapati9599]

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.

[@learnwidgiggs]

Many many Congratulations 🎉

[@rohanbhattacharyya6600]

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.

[@learnwidgiggs]

Glad to hear this.

[@vinodkumarhs4000]

Excellent applied today for real time problem

[@learnwidgiggs]

Glad to hear this 😊

[@vishalsonawane.8905]

Please upload Dataset for this videos so we will understood properly??

[@rajatdixit11]

Awesome as always ❤ Thanks for such insightful videos😊

[@learnwidgiggs]

Welcome bhai 😊

[@pradeeppadeliya]

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

[@learnwidgiggs]

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.

[@krishnakantapanda6835]

Simple yet effective

[@learnwidgiggs]

Glad you think so!

[@PREETISHARMA-w6f5k]

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.

[@adilumr6359]

Can you explain why the total was wrong in the first place? How did it get the wrong count of 25164?

[@learnwidgiggs]

Because the filter context was not traveling correctly to totals row..that's what I have explained in the video..plz watch it again

[@yeldanabaltabayeva]

thanks a lot, your video really helped me solve my problem

[@learnwidgiggs]

Glad to hear this!

[@amandev8794]

Hello Sir, its giving Total not distinct count pls help PcountV1 = if(HASONVALUE(Orders[Product Name]), [Pcount] , SUMX(Orders, [Pcount]))

[@seepanameghana8828]

But why total values shows incorrect in the given question

[@learnwidgiggs]

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.

[@learntradingbysanukumar7990]

Hey, bro ...Do you provide training/ coaching?

[@satishkarkare1814]

superb