Published on Aug 02, 2021:
In this video, we will learn to propagate filters between unrelated tables using DAX TREATAS function.
In the previous video, we discussed the highly denormalised fact tables in Power BI. The impact of highly denromalised fact tables can be that the data does not filter correctly between the two fact tables as there is no common dimension joining the two fact tables.
Previous Video: youtu.be/qFyUDN0JNT0
SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel,SQL Server and Python!!
youtube.com/channel/UCYYHFZpm5GbaOmQKDNSTGLw
Download M Query code:
bit.ly/3kJwUUq
Our Playists:
Extract Load and Transform data using Power Query: bit.ly/3orLRf4
Enhance Power BI Data model using DAX: bit.ly/2GbTENc
Python and Power BI: bit.ly/2EajdNc
Getting Started with AWS: bit.ly/2PgSCQX
SQL Playlist : goo.gl/PS5Ep6
DAX PlayList : goo.gl/S4W41D
Power BI PlayList: goo.gl/dXxvnB
Power Query Playlist: goo.gl/5QS7P4
Getting Started with Power BI: goo.gl/GHakLZ
Getting Started with Python: goo.gl/n24P3w
Data Science With Python: goo.gl/PeYCR5
Power BI service: tiny.cc/sjekmz
Data Modelling with Power BI: tinyurl.com/8b4srjrm
ABOUT DAGDOO:
Website:
Home Page: dagdoo.org/
Power BI Tutorials: dagdoo.org/excel-learning/tutorial-power-bi-desktop/
Questions? Comments and SUGESTIONS? You will find me here:
Twitter: @dagdooe
Category: Science & Technology
License: Standard YouTube License
- Propogating Filters between unrelated tables using TREATAS DAX Power BI ( Download)
- Treatas DAX in Power BI | Unrelated Tables ( Download)
- CALCULATE in DAX #10: Using TREATAS ( Download)
- Advanced Dax Made Easy: TREATAS Relate an Unrelated Table ( Download)
- 2 TREATAS helps to display slicer values from an unrelated table | Real-Time Problem in Power BI ( Download)
- Power BI TREATAS function| Pass text as a parameter in pbi | get values from a disconnected table ( Download)
- Avoid relationships using TREATAS DAX function // Beginners Guide to Power BI in 2021 ( Download)
- DAX TREATAS function not showing the correct numbers Power BI ( Download)
- Power BI Filter data from an unrelated table ( Download)
- TREATAS - DAX Guide ( Download)
- 013. 3 DAX trick to CALCULATE (cross filter) between Unrelated Tables in your Data Model ( Download)
- What is TREATAS DAX function and how to use it in Power BI | DAX Sundays | BI Consulting Pro 4K ( Download)
- Power BI DAX Tutorial (16/50) - What is TREATAS Function ( Download)
- Filters based on content of other tables in Power BI - Unplugged #44 ( Download)
- DAX Function TREATAS in Power BI ( Download)
