TreatAs is helpful for filtering, and it doesn't filter only based on one column, it can filter based on as many as columns you want. One of the challenges in Power BI relationships is creating a relationship based on multiple fields, I have previously explained a method you can use to create a compound key and use that for the relationship. Another method is to use TreatAs. Let's see how TreatAs can help in that scenario.
download the PBIX file with links to study more from here:
radacad.com/creating-relationship-based-on-multiple-fields-in-power-bi-using-treatas-dax-function
*******************
Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.
RADACAD courses: learn.radacad.com
Become an academy member: learn.radacad.com/product-category/membership/
*******************
********
CONNECT with US!
********
-- twitter.com/radacad_com
-- twitter.com/rad_reza
-- twitter.com/leila_etaati
-- facebook.com/radacad
-- linkedin.com/company/6393399
-- radacad.com
********
- Relationship Based on Multiple Fields in Power BI Using TREATAS DAX Function ( Download)
- CALCULATE in DAX #10: Using TREATAS ( Download)
- Avoid relationships using TREATAS DAX function // Beginners Guide to Power BI in 2021 ( Download)
- DAX Sketches w/ Brian Grant: Creating a TREATAS Relationship ( Download)
- Relationship in Power BI with Multiple Columns ( Download)
- Building a Virtual Relationship in Power BI Basics of TREATAS DAX Function ( Download)
- Creating Virtual Relationships Using TREATAS - Advanced Power BI Technique ( Download)
- DAX Sketches w/ Brian Grant: An Intro to the TREATAS Function ( Download)
- Create Relationship Based on Multiple columns - Power BI Desktop Tips and Tricks (44/100) ( Download)
- Propagating filters using TREATAS in DAX ( Download)
- Comparing TREATAS vs USERELATIONSHIP in Power BI ( Download)
- Age Banding in Power BI Using TREATAS DAX Function Relationship Based on Between ( Download)
- Power BI TREATAS function| Pass text as a parameter in pbi | get values from a disconnected table ( Download)
- Relationship DAX Functions in Power BI | USERLATIONSHIP And CROSSFILTER DAX Function ( Download)
- Propogating Filters between unrelated tables using TREATAS DAX Power BI ( Download)
