Visualizing the filter/evaluation context

DAX DAX Calculations
1
  1. Connect to DAX Studio and Select Define Filter Dump Measure:
    1
    11103×629 47.2 KB
  2. Copy the code
    2
    21066×595 54.4 KB
  3. Create a measure and paste the code removing the DEFINE and MEASURE statement
    6
    6835×789 29.6 KB
  4. Create a blank page and change the detail to Tooltip and add card visual
    3
    31632×871 46.1 KB
  5. Go to your report and select the visual on which you want to see the filter context, and enable tooltip
    4
    41627×751 64.1 KB
  6. Hover over the report
    5
    51355×803 46.4 KB

    See the Filters.pbix (2.9 MB)
4 Likes
2

@AntrikshSharma,

Terrific tip - thanks very much for taking the time to write it up in such a clear, stepwise way.

I have found this dumpfilters technique invaluable for debugging measures with complex filter context interactions.

  • Brian
1 Like
3

Yup, I use this in every report as after few slicers I always forget what the filter context is lol!

4

@AntrikshSharma
Great post! Thanks for sharing

1 Like