22nd September 2025
Power BI – Use ISINSCOPE to improve a Matrix
I recently had a request for totals in a Matrix to be shown for some columns and not for other columns. My solution was to use ISINSCOPE in a Matrix to work out which level of the matrix to choose what to return. Scenario At an event you sell tickets. So for the Cheese and Wine evening we can see...