Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello
I need to calculate a percentage of how many times a value has been overwritten based on the total records for a selected period. To simplify things, lets just say that i need to show the minimum date based on the slicer only. This can be displayed correctly based on the below screen. The measure definition used is:
The problem is that when i am filtering the above table to exclude the Times Overwritten % that are below 1, i see as a date the 6/2/2023.
What i would like to do is to always show the min date based on the slicer, ignoring the date that is on the matrix.
Any help would be appreciated, since i am stuck for some time now...
Thanks
George
Thanks for your reply, but using All will also remove the filter from the slicer, so its not an option
User | Count |
---|---|
14 | |
9 | |
7 | |
7 | |
6 |
User | Count |
---|---|
22 | |
11 | |
10 | |
10 | |
8 |