The concept of context is a huge strength of the DAX language. The ability to create a single calculation whose value changes based upon contextual filters is fundamental to the proper operation of Power BI reports and dashboards. However, troubleshooting and debugging context can prove challenging as it is sometimes difficult to know exactly what context filters might be operating on a particular DAX calculation. This recipe provides techniques to assist in troubleshooting and debugging context issues by leveraging three special DAX functions: FILTERS, ISFILTERED, and ISCROSSFILTERED.
To prepare for this recipe, perform the following steps:
- Open Power BI Desktop.
- Use an Enter Data query to...