Is it possible to apply filters at table visual level (basic/advanced from filter pane) to a measure

[ICD]

Hi!

I need help:  is it possible to apply filters at table visual level (basic/advanced from filter pane) to a measure in card visual?

I have:

  one slicer by project  

  table visual with property units filtered by this slicer:  (data in table visual: property unit code, building code, area ,...etc.)

  one card visual - showing the measure for count of property units

msPUCount_ALL = 

CALCULATE(

COUNT(PropertyUnit[PropertyUnitId])

                )

When I filter by project (slicer) the measure is correct calculated.

When I apply basic filter by building on table visual level, not on page level => this filter is not applied to the measure.

I tried to add ALLSELECTED , KEEPFILTERS - without success

msPUCount_FilteredALLSELECTED = 

        CALCULATE(

            [msPUCount_ALL],

            ALLSELECTED(PropertyUnit)

            )

When I hide the filter by building at table level and add filter by  building at page level, the measure is correct calculated, but the possible buildings in filter pane are not filtered by project slicer

[Anonymous]

Hi  @ICD ,

As far as I know, the slicer works on the visual associated with the whole page, and the visual level only works on the visual itself, not on the other visuals.

You can set up three different levels of filters for the report in the Filters pane:

• The visual level. -- You can also add visual level filters to filter this visual.
• The page level. -- You can also add a page-level filter to filter an entire page.
• The report level. -- You can also add a report-level filter to filter an entire report.

Add a filter to a report in Power BI - Power BI | Microsoft Learn

If you only want to filter one or two visuals on the entire page without affecting the other visuals, you might consider using a slicer and then using Edit interactions to cancel the slicer's effect on the other visuals

Change how visuals interact in a report - Power BI | Microsoft Learn

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.

[ICD]

Hi, @Anonymous 

Thank you for your answer! My question is:  Is it possible to apply filters at table visual level (basic/advanced from filter pane) to a measure.

Is your answer - No?

Best regards,

@ICD