[@harishkumar-v2i]

The question was to find female contribution in the total sales.
[Sales by Female in 3 locations] / [Total sales]

[@karthikrajag6796]

recent interview questions in capgimini
1) I have 4 visual and 2 slicers . How many queries will run if I refresh this
2 ) can we switch to import to DQ or DQ to import mode in middle of the developement in PBI.
3) Difference between Slicer and filter
4) I filter a value from filter pane , will it reduce the performance.
5) I have huge data like 5 gp of data, how will you handle
can you answer for these also . Interview happened on 18th April 2024

[@learnwidgiggs]

Noted.

[@sanjeevchaurasia1261]

Thankyou sir for sharing this valuable video.
if i had to write this DAX, my approach would be this
Total_Sales =

VAR filter1 = FILTER( Sales , Sales[Gender] = " F " )
VAR filter2 = FILTER( Sales , Sales[State] IN { "Karnataka", "Maharastra", "Gujarat"})
RETURN
CALCULATE( SUM(Sales[Amount]),filter1,filter2)

[@amitkumarsingh8936]

The comment section is also very informative guys

[@digvijaygore7203]

Great work man ❤

[@ghoshsubhosmita]

thank you shashank for sharing this

[@atharwaborkar6778]

Good

[@vishalshelar4886]

Sir what mean by Freelansing work please make a video of freelancing data analytics job

[@beneficial4u572]

Very Useful, thanks for sharing.

[@learnwidgiggs]

Glad you found it useful 🙂

[@rakeshricky7015]

Perfect Explanation 👏

[@learnwidgiggs]

Glad to hear this 🙂

[@Naveen_9959_kumar]

Hello sir , can you share about resume for freshers

[@Zigzag12370]

Hi bro I am worked in other domain now I am training on power bi developer how can I get job as fresher can u suggest roadmap.

[@salmankhan-fb1fj]

don't waste time in power bi bro

[@datayogi_]

Query - I think as we are using calculate, we dont need to add filter function, we state the conditions directly, pls correct me if I am wrong

[@learnwidgiggs]

But that will not be an optimized solution

[@datayogi_]

@@learnwidgiggs Okay

[@shalinisrivastava7250]

Thank you so much sir,

[@AakashYadav-kb2qn]

Thankyou giggs bhai

[@LaxmiChinta-q1z]

Great explanation sir

[@anunaydubey7174]

Thanks for sharing this Sir❤

[@learnwidgiggs]

Welcome 🙂

[@kamalgopalsingh244]

We could have used visual level filter to filter condition??is it not professional way ????

[@ArpitPawar-kk1wr]

This formula is showing error that sum cannot work with value of type string.

[@SandipanSarkar-c8v]

Finished watching

[@moodituupoo1727]

Do they keep aptitude test before technical test in MNC's?

[@joydeepsen594]

Total Sales =
var a = CALCULATE(SUM(Sales[Amount]),Sales[State]="Gujarat" && Sales[Gender]="F")
var b = CALCULATE(SUM(Sales[Amount]),Sales[State]="Karnataka" && Sales[Gender]="F")
var c= CALCULATE(SUM(Sales[Amount]),Sales[State]="Maharastra" && Sales[Gender]="F")
var d=a+b+c
return d

[@nitinsharma2019]

Also upload the dataset for practice

[@bloggingbyasifali4984]

Hi sir can u plz make video for 3+ powerbi developer resume.

[@shalakamohite1076]

Thank you sir

[@sonalisinghal988]

Amazing video sir🙏

[@learnwidgiggs]

Glad to hear this 🙏

[@TeluguTonicGlobal]

Greate Explanation sir

[@learnwidgiggs]

Glad you found it helpful 🙂

[@keerthiraj3498]

Tqsm bro ❤

[@learnwidgiggs]

Welcome 🙂

[@vikas261196]

isn't it too easy from the interview point of view ?

[@shivshankarkumar7446]

Another approach:
Total sales =
SUMX(
FILTER(
Sales,
Sales[Gender] = "F" &&
Sales[State] IN {"Karnataka", "Maharashtra", "Gujarat"}
),
Sales[Amount]
)

[@Aaradhya_Jauhari]

Compute intensive

[@mohammedowais4908]

SUMX is an iterator function and the DAX will be slow in this case hence not recommended

[@SUEZ_DATA]

Very nice

[@learnwidgiggs]

Thank you 🙏

[@carcrazynishant]

🫡🙏 thank you

[@Zigzag12370]

Hi