Slicer to not filter the data calculated but filter the visual

[Nobie]

Hi folks,

I need a help.

Is there something possible, I have created a measure. I want the measure value not to be filtered even other slicer I changed.

Changing the silver will only change the visual ,suppose earlier it was showing 10 rows with different values now it will show 6 rows with the same earlier value.

[v-yangliu-msft · Accepted solution]

Hi  @Nobie ,

I created some data:

You might consider using the IF() function to mark up and then put it in Filter to set it.

Here are the steps you can follow：

1. Create measure.

Rank =
IF(
    [Count]=6,
RANKX(
    FILTER(ALLSELECTED('Table'),[Count]=6),CALCULATE(MAX('Table'[Date])),,ASC),BLANK())

Flag =
IF(
    [Rank]<=6&&[Rank]<>BLANK(),1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

If I have misunderstood your meaning, please provide your desired output and your pbix without privacy information.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly