🔥 3-day streak
Microsoft Power BI Data Analyst102 / 205
Question 102 of 205

You maintain a sales report with a matrix visual that shows a [Total Sales] measure broken down by Product Category (rows) and Region (columns). Business users complain that when they collapse the matrix to view only the grand total, they want the [Total Sales] measure to display blank instead of the aggregated value to avoid confusion during drill-through review. You need a measure that returns the sales value only when the visual context is filtered to a specific Product Category, and returns blank at the grand-total level. Which DAX function should you use to detect whether the Product Category column is currently being filtered?

Reviewed for accuracy · Report an issueNext question