SS Supply Chain Solutions Power BI Developer Interview Questions and Answers

ALL returns all the values in a column, while FILTER applies a filter to the values in a column.

• ALL ignores any filters applied in the report, while FILTER respects the filters.

• ALL is used to remove any filters from a column, while FILTER is used to apply a specific filter.

• Example: ALL('Table'[Column]) vs FILTER('Table', 'Table'[Column] = 'Value')

Calculated columns are static values calculated at row level, while measures are dynamic aggregations calculated at query time.

• Calculated columns are stored in the data model and can be used in visuals directly.

• Measures are not stored in the data model and are calculated on the fly based on the context of the visualization.

• Calculated columns are useful for creating new columns based on existing data, while measures are