cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors