Forum Discussion

gap's avatar
gap
Helper I
3 years ago

Keep filter from visual - Ignore row context

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

 

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    gap , Try with all

     

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

    • gap's avatar
      gap
      Helper I
      3 years ago

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