📊 Power BI DAX: Related Versus RelatedTable

[@chocym4965]

I look at so many related and relatedtable, only yours makes sense to me. And you explain so to the point!

[@bladerunner-pf1mj]

Very informative. I really admire the way you explained the concept.

[@emilyamalkin4367]

Great explanation - very clear and nuanced! Thank you so much! ❤

[@cesarvdplas8217]

Thanks! very professional approach in teaching. All very clear

[@nebojsanedeljkovic1272]

Great explanation for RELATED and RELATEDTABLE function!

[@PragmaticWorks]

Glad you enjoyed!

[@nitinsharma4121]

You just made my life a lot more beautiful ❤️ Thanks a lot 🙏

[@haraldfuchs2762]

Great explanation, thank you!

[@eagillum]

Thanks, this helped.

[@PragmaticWorks]

You're welcome!

[@martyc5674]

Brilliant 🎉

[@MrThapaliya233]

Very well explained, Thanks.

[@PragmaticWorks]

You are welcome!

[@dbalkin777]

If you already have those other dimensions in your data model, what is the need for adding calculated columns and repeating that information elsewhere? Wouldn't this be considered a redundancy?

[@TheAlgebraTeacherPOWERStoBI]

Douglas you are absolutely correct. I wanted to showcase with an easy dataset the difference between the two DAX functions. I would definitely do most of those transforms through merges in the Power Query editor. I've worked with some reports in Virtual Mentoring sessions where the user wanted to get an aggregation on a Dimension table in order to transfer conditional logic for a calculated column or someone is connecting to a live dataset and they don't have the ability to go back in the Power Query editor to modify so this was their only workaround.

[@TechTeacherTT]

Great comment and explanation. Valuable info!!

[@dbalkin777]

@@TheAlgebraTeacherPOWERStoBI that makes sense! Really great explainer on the difference between the two--thank you for sharing!

[@bhakthasingh8198]

Excellent explanation!!

[@PragmaticWorks]

Thank you!

[@ravichandirana8911]

Hiii Do you know any websites to practice DAX Like Hacker rank for SQL

[@danew637]

Look like relate is working with dimension and relatetable is working with fact table ?

[@edsta714]

Is there a way to do that in Query editor in one step without having to group by aggregate the table, then merge?

[@sonetmollick4630]

What a great explanation :)

[@PragmaticWorks]

Glad it was helpful!

[@krishnakishorepeddisetti4387]

Quick question.. might be a stupid question...how did you increase the font size of formula bar... By the way... amazing video and great explanation. Support and love from India Thanks and Regards Krishna Kishore P

[@TheAlgebraTeacherPOWERStoBI]

Thanks for the kind words. With the mouse cursor in the formula bar if you hold down the shift key and scroll up on your mouse wheel it will increase/decrease the formula text.

[@mdnaiyaz7167]

Then why we not use Calculate(sum(tablename[columnname]),filter(tablename,table[playerid]=table[playerid]))

[@davidignatius1]

Well, why do Related and Related table explained here are not explained in conjunction with cardinalities? Confusion can arise so easily with those who are new. Come on.

[@notoriousft]

Video caps has a typo.

[@EnneagramTarot-zu8kp]

1:30- RELATED 4:58- RELATEDTABLE