Keep filter from visual - Ignore row context

gap — Wed, 08 Feb 2023 12:37:21 GMT

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:

CALCULATE(MIN('Noonreports Override Value'[FromUtc]), ALLSELECTED('Noonreports Override Value'[FromUtc]))

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

Re: Keep filter from visual - Ignore row context

amitchandak — Wed, 08 Feb 2023 17:35:17 GMT

gap , Try with all

CALCULATE(MIN('Noonreports Override Value'[FromUtc]), all('Noonreports Override Value'[FromUtc]))

Re: Keep filter from visual - Ignore row context

gap — Thu, 09 Feb 2023 10:36:06 GMT

Thanks for your reply, but using All will also remove the filter from the slicer, so its not an option

topic Keep filter from visual - Ignore row context in DAX Commands and Tips

Keep filter from visual - Ignore row context

Re: Keep filter from visual - Ignore row context

Re: Keep filter from visual - Ignore row context