Filter Functions & Relationship functions | Power BI |

Video Link: https://drive.google.com/file/d/1YM5FuNZIeZm51czWpUt_J_J201pdnJJH/view?usp=sharing

🔎 Filter Functions in Power BI -DAX
Filter functions are used to return subsets of data based on conditions. They allow precise control over calculations beyond what slicers or visual filters provide.

Common Filter Functions
FILTER table, condition
Returns a table where rows meet the specified condition.
Example: FILTER Sales, SalesAmount 1000

ALL table column
Ignores filters applied to a table or column. Useful for calculating totals or percentages.
Example: CALCULATE SUMSalesAmount, ALLSales

ALLEXCEPT table, column
Removes all filters except those on specified columns.
Example: ALLEXCEPT Sales, Sales Region

VALUEScolumn
Returns a distinct list of values in a column. Often used in dynamic measures.

RELATEDTABLE table
Returns all rows from a related table that are connected to the current row.

👉 Use case: Filter functions are essential for row-level calculations, dynamic measures, and scenarios where you need to override or customize filter context.

🔗 Relationship Functions in Power BI
Relationships define how tables connect in the data model. They allow filters to propagate across tables, ensuring consistent results.

Key Relationship Functions
RELATEDcolumn
Fetches a value from a related table.
Example: RELATEDCustomerCustomerName

RELATEDTABLE table
Returns a table of rows related to the current row.

USERELATIONSHIP column1, column2
Activates an inactive relationship for a calculation. Useful when multiple relationships exist between tables.
Example: CALCULATESUMSalesAmount, USERELATIONSHIPSalesDate, CalendarFiscalDate

CROSSFILTERtable1column, table2column, direction
Controls filter propagation direction single both

Видео Filter Functions & Relationship functions | Power BI | канала SomuDataGeek