Remove filters from a dimension

EstherBR I believe you could create a measure like the following:

Sum of Sales = CALCULATE( SUM( 'Table'[Sales] ), REMOVEFILTERS( 'Table'[Level] ) )

1. Create a tooltip page

   • In Power BI, add a new page.

   • Go to Page Information and turn on Tooltip.

   • Set Page Size to Tooltip under Page settings.

2. Add a table visual

   • Add Category, Level, and Sales fields to the visual.

   • This will display all levels for each category.

3. Ignore Level filter using ALL()

   • Create a measure like this:

      

     Total Sales (Ignore Level) = CALCULATE( SUM('Table'[Sales]), ALL('Table'[Level]) )

4. Use Category as the filter context

   • Add Category to the tooltip visual to ensure it filters by category only.

   • Don’t include Level in the tooltip filters.

5. Set up the tooltip for the main visual

   • Go back to your main table (filtered by Level = 4).

   • In the Format pane, under Tooltip, set the type to Report page and choose your tooltip page.

Now, when you hover over a category, you’ll see sales for all levels of that category, even though your main table is filtered by Level 4.

Thanks GeraldGEmerick, one last question. If I remove the sum of sales from the tooltip. Can I still display the category by all levels?

Thankyou, GeraldGEmerick and Shubham_rai955for your responses.

Hi EstherBR,

We appreciate your inquiry to the Microsoft Fabric Community Forum.

We are glad that your issue has been resolved, and we thank you for sharing the solution. Your contribution will be helpful to other community members facing similar problems. If you have any further queries, please feel free to contact the Microsoft Fabric Community.

Thank you.

Hi EstherBR , It good to hear that the problem has been solved.

Hi EstherBR 
You could create a new ID column

Build a separate table for the tooltip using this new ID

Relate the main table and the tooltip table through the new ID

Use the tooltip table in the tooltip page visuals

This breaks the Level filter propagation while still keeping the Category context.

Alternative (DAX-based):
Use a measure that ignores the Level filter:

Total Sales (All Levels) =
CALCULATE(
SUM('Table'[Sales]),
REMOVEFILTERS('Table'[Level])
)

To remove a dimension filter in a tooltip, either decouple the model (new ID/table) or override the filter using DAX (REMOVEFILTERS / ALL).

Did it work? ✔ Give a Kudo • Mark as Solution – help others too!
Regards,
Rufyda Rahma | MIE