Create Table of Records Using Rows Counted in Measure

[JamesMarquezDev]

I'm trying to create a table that displays the values in each column that a measure is counting. For example, I have a source table with ID's and Dates for each row. I'm using many conditionals to calculate various statistics using measures. Next, I want to create a mirroring table that displays the ID and Date for each record that is being counted in the result of the measure. It must be dynamic as there is a slicer that allows the user to select desired date ranges to update the measures. I want the table to update with the records that are being counted in the measure when selecting different date ranges. Is this possible? I can't figure it out after much research and trial and error. Thank you.

[parry2k]

@JamesMarquezDev Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[JamesMarquezDev · Accepted solution]

I found my answer. It's really simple. Drag the same measure into the filter pane and set the value equal to 1. This will filter to only the records that meet the measure's criteria, and thus show you those records that are being counted by the measure.