Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
@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
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |