# Power BI - DAX and Advanced Dashboards (Data Analytics) > DAX (measures, calculated columns, CALCULATE, FILTER, ALL), drill-down, bookmarks, publishing - 20 interview questions - Senior - [Interview Questions: Data Analytics](https://sharpskill.dev/en/technologies/data-analytics/interview-questions.md) ## 1. What is the fundamental difference between a measure and a calculated column in DAX? **Answer** A measure is calculated dynamically with each user interaction (filter, slicer) in the current visualization context, while a calculated column is evaluated once during data load and stored in memory within the table. Measures are optimal for aggregations and KPIs that change based on context, calculated columns for fixed attributes requiring sorting or grouping. ## 2. What is the main role of the CALCULATE function in DAX? **Answer** CALCULATE is the most powerful DAX function as it allows modifying the filter context in which an expression is evaluated. It takes an expression as its first argument, followed by one or more filters that replace or modify the current context. This enables creating measures that ignore certain filters or add new ones, regardless of slicers applied by the user. ## 3. Which DAX function should be used to remove all filters from a table or column in a measure? **Answer** The ALL function removes all filters applied to a specified table or column, allowing to get the grand total regardless of active slicers. It is often used with CALCULATE to compute percentages of total or comparisons with the entire dataset. ALLEXCEPT is a variant that removes all filters except those from specific columns. ## 17 more questions available - How to calculate the percentage contribution of a category relative to the grand total in DAX? - What is the difference between ALL and ALLEXCEPT in DAX? Sign up for free: https://sharpskill.dev/en/login ## Other Data Analytics interview topics - [Google Sheets - Fundamentals](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/google-sheets-basics.md): 20 questions, Junior - [Google Sheets - Advanced Formulas](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/google-sheets-advanced.md): 20 questions, Junior - [SQL - Fundamentals](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/sql-basics.md): 25 questions, Junior - [SQL - Aggregations and Grouping](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/sql-aggregations.md): 20 questions, Junior - [SQL - Joins](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/sql-joins.md): 20 questions, Junior - [BigQuery - Fundamentals](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/bigquery-fundamentals.md): 20 questions, Junior - [Data Cleaning](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/data-cleaning.md): 20 questions, Junior - [KPIs and Business Metrics](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/kpis-metrics.md): 20 questions, Junior - [Descriptive Statistics](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/descriptive-statistics.md): 20 questions, Junior - [Zapier and No-Code Automation](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/zapier-automation.md): 20 questions, Junior - [Data Visualization Principles](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/data-viz-principles.md): 20 questions, Junior - [Python & Pandas - Fundamentals](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/python-pandas-basics.md): 20 questions, Junior - [Google Sheets - Automated Dashboards](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/google-sheets-dashboards.md): 20 questions, Mid-Level - [SQL - Subqueries and CTEs](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/sql-subqueries-ctes.md): 20 questions, Mid-Level - [SQL - Window Functions](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/sql-window-functions.md): 20 questions, Mid-Level - [BigQuery - Advanced Features](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/bigquery-advanced.md): 20 questions, Mid-Level - [Data Modeling](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/data-modeling.md): 20 questions, Mid-Level - [Funnel and Conversion Analysis](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/funnel-analysis.md): 20 questions, Mid-Level - [Cohort and Retention Analysis](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/cohort-retention.md): 20 questions, Mid-Level - [Google Tag Manager and Tracking](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/gtm-tracking.md): 20 questions, Mid-Level - [APIs and Webhooks](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/apis-webhooks.md): 20 questions, Mid-Level - [dbt - Fundamentals](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/dbt-fundamentals.md): 20 questions, Mid-Level - [AB Testing and Applied Statistics](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/ab-testing.md): 20 questions, Mid-Level - [Looker Studio (Google Data Studio)](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/looker-studio.md): 20 questions, Mid-Level - [Power BI - Fundamentals](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/power-bi-fundamentals.md): 20 questions, Mid-Level - [SQL - Advanced Analytical Queries](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/sql-advanced-analytics.md): 20 questions, Senior - [dbt - Advanced Features](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/dbt-advanced.md): 20 questions, Senior - [Python Analytics - Advanced Analysis and ML](https://sharpskill.dev/en/technologies/data-analytics/interview-questions/python-analytics-advanced.md): 20 questions, Senior --- Source: SharpSkill (https://sharpskill.dev), tech interview preparation for your real stack. HTML version of this page: https://sharpskill.dev/en/technologies/data-analytics/interview-questions/power-bi-dax