Filter within calculated measure not included in other visuals

[Hubanl]

I hope someone can explain why the filter within my measure it not included in other visuals. Some sample sales data is added.

I created a measure which computes the number of blue items:

Number of blue items =

    CALCULATE(

        SUM(Sales[Amount]),

        Sales[Color] = "Blue"

    )

This measure is added to pie chart visual. Now when i click the product 'bike' in the pie chart, this 'filter 'is included in the other visual on the left. However, the filter (Sales[Color] = "Blue"), is not included in the other visual. Why not? Because, i feel like this should work this way.

It does work when i apply a filter 'Color = Blue' directly on the pie chart visual

    

Some sample data:

Customer	SaleDate	Product	Amount	Color
A	1-1-2020	bike	3	Blue
B	1-1-2020	helmet	1	Red
C	1-1-2020	bike	3	Red
D	1-1-2020	glasses	1	Red
A	1-1-2020	bike	1	Red
C	1-1-2021	helmet	3	Red
D	1-1-2021	bike	2	Blue
A	1-1-2022	glasses	2	Blue
E	1-1-2022	bike	1	Blue
C	1-1-2022	helmet	4	Red
A	1-1-2022	bike	2	Blue
B	1-1-2023	glasses	4	Blue
F	1-1-2023	bike	1	Blue
C	1-1-2024	helmet	3	Blue
D	1-1-2024	bike	3	Blue
A	1-1-2024	glasses	2	Red

Thanks in advance!

[Ashish_Mathur]

Hi,

In the tooltip, you will not see the condition of blue but if you have dragged the same measure to the first visual as well, then the figures should be correct.

[bhanu_gautam]

@Hubanl , Use a slicer for this and select blue 

[Hubanl]

Well in this case that is probably the best option. However, this is just a simplified example. I got measures with multiple filters and i want it to be interactive with other visuals. Is that possible with a calculated measure?

[Anonymous · Accepted solution]

Hi @Hubanl 

This is by design. The filters defined in measures cannot interact with other visuals. This is because these filters only take effect in the current context of a visual where the measure is placed. While in other visuals, the context is different and independent. 

Slicers, filters in Filter Pane and filter interaction between visuals can pass filters on other visuals. These filters can be thought of as external filters. If you want one filter to affect multiple visuals through interactive behavior, we recommend using these external filters. 

Tour the report Filters pane - Power BI | Microsoft Learn

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!