Scenario: Calculate() vs Calculatetable() | DAX | Power BI Interview🔥

Intro Credits - InVideo
The motive of this video is to help you all in cracking the Interviews of different companies for Power BI Developer position, so please support each other, share the video and grow together.
Link for the Power Bi Interview QnA playlist :
• Power BI Interview QnA
Link for the SQL for Power Bi Interview QnA playlist :
• SQL Interview QnA for ...
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

[@kurticotton]

you should also share data for practice.

[@SandeepSingh-cy4hw]

dax=calculate((table[profit]),table[color]='red') dax=sumx(calculatetable(tablename,table[color]='red'),table[profit])

[@JayeshTatipamul]

Thanks for introducing us to the CALCULATETABLE DAX function.

[@learnwidgiggs]

Our pleasure!

[@tusharwalunj533]

Thnx for video... Please create video on how to handle many to many relationship using different ways .

[@learnwidgiggs]

Will do it soon!

[@surajdarade1514]

Plz give datasets in description so that we do practice it really helpful plzzzzzzzzz

[@amitkumarkumarsinghpiyush323]

Bhai ek cheez bhut common h aapke video me itne saare logo ne comments kiya h data set k liye but sbko ingore kr rhe ho aisa mt kro log practice kaise krenge?

[@FaisalMasood-q6g]

Bro at first instance it looks helpful but without seeing data how we can understand what is going on behind the scene? pls keep in mind our request, even if you go for interview, you have to give background with problem statement.

[@learnwidgiggs]

@@FaisalMasood-q6g sure, noted.

[@anjaligondse]

Thanks for this series 🙌

[@learnwidgiggs]

Glad to hear this Anjali 😊

[@saiendeavours2154]

We can show Red colour profit by using a visual level filter right, why should we go for a measure?

[@shivanichaudhari9095]

Sir you said time Taken for execution for calculatetable is less but the dax for calculate is easy right?? Plz guide

[@learnwidgiggs]

We always try to make our Dax code optimized..so thats why I have mentioned that point Yes through "calculate" it's easy

[@Sandeepsingh_unique]

why did not you explain it properly like why you are use this function and explain in brife this function in your every video just you are typed dax function but do not tell why this function ?

[@RSJSqUaD]

What about the source file sir? Atleast, tell me how to download it from GOOGLE sir? I have MS SQL and MY SQL app in my laptop sir? Kindly Guide

[@learnwidgiggs]

Free datasets are present on - kaggle, check out this.

[@quadirnawaz67]

@@learnwidgiggsPlease drop the link, so that we can download it from there.

[@harithagolla6241]

Please create a video for dax functions

[@learnwidgiggs]

Will do it soon 👍

[@harithagolla6241]

Thank you

[@banu7389]

Kindl share your Data sets and same DAX formula for practice

[@Happymen-u]

Sir, why Calculate table will take less time in execution, as u are using sumx function also; which is a iterator function, it will check row by row; don't u think it will take more time than Calculate. Please explain it sir

[@learnwidgiggs]

Check through DAX editor..to get the real time timings.

[@vishalsonawane.8905]

SUMX function under the CALCULATETABLE function is not working... don't know?

[@learnwidgiggs]

It should work, plz debug your Dax code properly.

[@vishalsonawane.8905]

@@learnwidgiggs i have try Many by using SUMX function but they showing debug as " The expression specified in the query is not a valid table expression "

[@learnwidgiggs]

@@vishalsonawane.8905 then you are not providing the table in the correct form..in its argument.

[@meghalohar2367]

helpful

[@AmitKumar-fp6re]

pls can you upload this power bi file

[@UmaMukherjee-y4l]

You would get the file from udemy course named Maven Analytics Powerbi Desktop

[@ashokreddy3300]

Make more vedios

[@themightyvk]

Thanks