Power BI Row-Level Security And Where To Filter
https://www.youtube.com/watch?v=9wN33rTaiB4
Gives example using a bridge table as well as the LOOKUP function.
Parent-Child Hierarchies
https://www.daxpatterns.com/parent-child-hierarchies/
Popular posts from this blog
Difference between DISTINCT and VALUES in DAX
https://www.sqlbi.com/blog/marco/2011/03/08/difference-between-distinct-and-values-in-dax/ Example: If a FACT table contains values that do not exist in a related DIMENSION table, a BLANK row is automatically added to the DIMENSION table. This DIMENSION row with the BLANK value will join to any FACT row where the column value does not exist in the DIMENSION. DISTINCT will NOT include the BLANK column in the DIMENSION. VALUES will include the BLANK column in the DIMENSION.
Comments
Post a Comment