cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper II

## Slicer to not filter the data calculated but filter the visual

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.

1 ACCEPTED SOLUTION
Community Support

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:

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

Community Support

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:

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