Power BI Interview | Scenario to calculate DYNAMICALLY TOP 'N' values

[@rajatdixit11]

This question was asked to me recently in Power BI interview in 2 of the Big 4 firms recently!! 😊

[@bidhanry9740]

hi rajatdixit11, if you don't mind could you please give me all the question you have faced in power bi interview?

[@sivakrishna_preneur]

How sashank was created buttons which are top 2 , top 3 and top 5?

[@mahendrapal3413]

@@sivakrishna_preneur I am also think that slicer which he is using top 2 top 3 top 5 is alrady availble in table or created

[@sivakrishna_preneur]

@@mahendrapal3413 go through buttons and selection concepts

[@dhrutijoshi3701]

Take a bow , I was searching for this for one challenge but at that time I couldn't do it. Finally got this now ...keep sharing such videos

[@learnwidgiggs]

Thanks 😊

[@vikassolanki297]

Rnk2 = var a1= If(HASONEVALUE(Orders[Product Name]),RANKX(All(Orders[Product Name]),[Total Sales],,DESC,Dense)) var a2 = If(a1

[@learnwidgiggs]

Great 👍

[@ramshataqdees5570]

please explain

[@zuebansari6799]

I have a question how to cretae relationship between this slicer and table, i am unable to do this, Please answer

[@learnwidgiggs]

Not required.

[@rajatdixit11]

Great content! As always.. Thanks a lot for your efforts 😊

[@learnwidgiggs]

My pleasure!

[@laxmankumar3388]

it has a context transition error. when we select top 2 on slicer. Total should be change but it's showing overall sale.

[@subbaraoballipale890]

u can use filter fun directly right for top 3 5 6 & relatable fun

[@shruti7463]

Hi shashank, video is quite good and helpful , if possible please make video on how to adjust this measure to get the correct total when top 3, 2 is selected. Thanks

[@learnwidgiggs]

@@shruti7463 Video is already published on ..Correcting the wrong totals. Plz check that out.

[@shruti7463]

@@learnwidgiggs Hi, I have seen that video, is it possible to make video on this scenario also to correct the total, as I have tried implementing the wrong total video in this scenario, but total is not coming correct. Thanks.

[@rajunalgunta6106]

@LearnWidGiggs is most valuable asset for students

[@learnwidgiggs]

Glad to hear this 😊

[@monishpilla4137]

Thank you for the video what if the client wants top 2,l least 3, least 6, in the slicer.

[@learnwidgiggs]

We have to modify the measure accordingly.

[@Regans5677]

hai while using this dax syntax is running correct but not showing data under the coloums ,just colomn names only, showing,can you plz correct this

[@saikumarp-s2t]

You were displaying product wise but want along with total seperate. Does it work because for me total are coming as table level and not as top n level

[@kanchans3556]

Please also tell how to dynamically change the column header (Top N Values)

[@suruvumohan583]

Hello, another way is there. Thanks for your great videos and information

[@learnwidgiggs]

You are welcome!

[@varunas9784]

Hi Shashank, good videos as always.. Is there a way to make the total displayed also sum accordingly to the selection made.. It seemed like the total here was always the same regardless of you selecting Top 2 or Top3 etc. Thanks in advance!

[@Sumitunstoppable]

Where can I get this sample file for practice

[@bindooo]

bro can you make a video on power bi with SQL server as a data source, like how to import and details that are being asked in the interview. this is widely asked in interviews nowadays.

[@learnwidgiggs]

Noted.

[@vikassinghjayara510]

I have learned a lot from you and adding a new skills everyday. This series is very good. Lot's of love from Delhi 😍 Sir, I am practicing all the videos of this series and preparing myself for PowerBi job interview. Can you please share more interview questions on other parts of PowerBi like Power View, Model, Power Query etc.

[@learnwidgiggs]

plz watch the first 8 videos of this playlist : kzbin.info/aero/PLk-s1KYuT-Pk2a1mbFe-nH7BNVdQjsWVU

[@vikassinghjayara510]

@@learnwidgiggs Thank you so much Sir. 😍 Will you upload more questions on that playlist? Or those questions are enough?

[@learnwidgiggs]

Currently you will find more videos on scenario based questions which are frequently asked.

[@vikassinghjayara510]

@@learnwidgiggs Thank you Sir for your valuable efforts. Nowadays, I am in a difficult time, therefore, asking that questions. I appreciate your work and the time which you are giving us.

[@learnwidgiggs]

No worries

[@abhinavjha3840]

how did you created that buttons for top 2 , top 3 and top 5

[@learnwidgiggs]

You can create a table in and enter those values manually

[@naveenshindhe2893]

@@learnwidgiggs how to get that button in that page, can you please reply

[@sureshboddana33]

hi bro how u link siler and topn values dax function relation. Could you please tell me . i cant get when i am trying

[@learnwidgiggs]

Can you tell me what part of the video you didn't understand

[@sureshboddana33]

@@learnwidgiggs i got bro . I have one scenario which is asked by PWC interview. I am unable to crack . could you please help me. If provide your email address. I will explain to you

[@mindofmagnet3373]

Thanks a lot

[@KiranKumar-rd1is]

Bro, Thanks for the video. Could you please share the Pbix file or data to practice.

[@SonuSonu-uh2er]

Can u prepare video on what are the steps followed by the Power BI developer while building a report like SDLC in software making.

[@learnwidgiggs]

okay, will plan.

[@nareshtekchandani2188]

Hi Shashank, Keep up the good work 👌👌 also, I want to understand while selecting the top 2 and top 3 and top 5 the total sales remained the same the total was showing for all the sales. can you help me with that?

[@learnwidgiggs]

If total is not working fine then measure has to be readjusted ..to make measure work for total also correct

[@rojalibiswal8975]

could u provide data set

[@ranjith1083]

please guide me, my rank list should be applied only for column values and not for total...so how this can be achieved

[@ashokreddy3300]

Use rankx function

[@lakshminarayana3168]

How to share interview questions which i faced recently

[@learnwidgiggs]

You can DM me on LinkedIn or you can send a mail..mail id there in the About section of the channel

[@JayeshTatipamul]

Helpful Video.

[@learnwidgiggs]

Glad it was helpful!

[@anasahmad5415]

do you teach live classes ? if yes then would ike to take classes

[@learnwidgiggs]

Don't take any Live classes as of now.

[@ashwinikhobragade7583]

This is real project scenario

[@learnwidgiggs]

Yess

[@vinodshinde8468]

Sir without using rankx also we achieve dynamic topn right sir please correct if I m wrong

[@learnwidgiggs]

Umm...you may also make use TOPN function in some way...you do it in some other way if possible and let me know and our audience plz.

[@tejaschaudhari9781]

This scenerio based question is for experienced one candidate or also for a Fresher candidate ....please reply sir!

[@learnwidgiggs]

Mostly experienced

[@ramshataqdees5570]

will question like these be asked to less than 2 year of experience

[@learnwidgiggs]

>=2 yrs

[@debapriyasaha5547]

Hi Shashank sir. Please start power bi live classes it will be helpful to many aspirant

[@learnwidgiggs]

Will try, thank you for suggesting

[@swapnilgupta2496]

Well explained bro but you are making it more complex instead we can add the calculate column in both the tables create the relation ship and then write a simple measure, it should not be that complex and it is not good to write these many dax

[@sureshsonti8097]

Hello Sir, I have question regarding the Total. If the Top 2 is selected, I get the B and D but the total is still 4445. How can I get the Total 2240. Thanks

[@learnwidgiggs]

Usually we don't show the totals but if you have to show then Dax code has to be modified and will upload a separate video on this.

[@ankushjain4128]

You are doing fabulous job ,your question collection is really good can relate in real powerbi interview questions .Please keep it up Here i think instead of using switch we can easily achieve same result in one line of code if([ranking]

[@learnwidgiggs]

Thanks for the solution,, hope it works.

[@reddyjogireddy6425]

Sir , what you wrote in top n values

[@learnwidgiggs]

At what point of time in the video?

[@ashokreddy3300]

Give me your contact,bro so together we can prepare

[@nishantpurohit100]

But the total is not changing, it should change as well, anyways nice video, appreciate your efforts.

[@learnwidgiggs]

Thank you.

[@kalyanibagal1849]

name city sales A 1 12 B 2 16 C 3 18 D 4 19 E 5 81 Suppose I have these 3 columns....and I want to add one column...and the condition is 12/(12+16+18+19+81).....like this ....how can we write dax for this

[@kalyanibagal1849]

Each time we have to divide sales by sum of all sales

[@learnwidgiggs]

Try this : Measure = Divide(tablename[sales], Sum(tablename[sales]))

[@kalyanibagal1849]

@@learnwidgiggs I want to add column

[@reddyjogireddy6425]

Give the rank on the basis of sales

[@reddyjogireddy6425]

Then add by rank wise

[@venusagarla4052]

Helo sir, Pls provide pbix file aslo to practice around.

[@provider65]

Share your contact bro, together we prepare

[@hairavyadav6579]

Top N values = var select_top = SELECTEDVALUE('Table'[Top]) var top_customer = SWITCH(select_top, "Top 1" ,IF([Ranking]