Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@gap , Try with all
CALCULATE(MIN('Noonreports Override Value'[FromUtc]), all('Noonreports Override Value'[FromUtc]))
Thanks for your reply, but using All will also remove the filter from the slicer, so its not an option
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 |
---|---|
54 | |
27 | |
23 | |
14 | |
11 |
User | Count |
---|---|
77 | |
63 | |
44 | |
17 | |
12 |