Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
User | Count |
---|---|
55 | |
46 | |
18 | |
16 | |
15 |
User | Count |
---|---|
115 | |
42 | |
41 | |
27 | |
22 |