Filter within calculate does not filter other visual

[Anonymous]

Hello,

I am new to Power BI and have been stuck with the issue that the filter in a Calculate function does not affect the filter context for another visual. I have created a small example. There is 1 table which holds responses to a survey for 3 customers. There are 4 columns: “Customer”, “Yes/No”, “Category” & “Question”. To make checking easier, each customer with “Yes” or “” in the “Yes/No” column has Category “Cat 1” and customers with “No” have category “Cat 2”.

Table = SELECTCOLUMNS( {
    ("Q1", "Customer 1", "Cat 1", "Yes"),
    ("Q2", "Customer 1", "Cat 1", "Yes"),
    ("Q3", "Customer 1", "Cat 2", "No"),
    ("Q4", "Customer 1", "Cat 1", ""),
    ("Q1", "Customer 2", "Cat 1", "Yes"),
    ("Q2", "Customer 2", "Cat 2", "No"),
    ("Q3", "Customer 2", "Cat 2", "No"),
    ("Q4", "Customer 2", "Cat 1", ""),
    ("Q1", "Customer 3", "Cat 1", "Yes"),
    ("Q2", "Customer 3", "Cat 1", "Yes"),
    ("Q3", "Customer 3", "Cat 2", "No"),
    ("Q4", "Customer 3", "Cat 1", "")
}, 
"Question", [Value1],
"Customer", [Value2],
"Category", [Value3],
"Yes/No", [Value4])

I have a measure to calculate the number of rows that are not blank in the “Yes/No” column.

Count Yes/No not blank = CALCULATE(COUNTROWS('Table'), 'Table'[Yes/No] <> "")

A Stacked bar chart is created with the Customer on the Y-axis and the measure on the X-axis. In the legend is the category. On the right of the bar chart there is another bar chart that shows the count of category (which represents the count of rows as the category is always filled).

The problem is that when a category is selected, the count of category still includes the rows that are blank in column “Yes/No” as the filter from within the calculate function is not in the filter context for the count of category (Filter context is extracted from DAX studio and displayed in the tooltip).

I would like to not use the “Filter on this visual” to prevent users of the report to change the filter on Yes/No as the blank rows should always be filtered out.

What should I change to have the filter on the “Yes/No” column also applied to the count of category visual?

[Anonymous · Accepted solution]

Hi  @Anonymous ,

Power BI does not support the direct passing of filters between our visual1 to visual2. 

If you want your visual show data that "Yes/No" is not the blank, I think you need to add the filter into the calculation.

I think you can use measure [Count Yes/No not blank] in your visual on right side instead of count Category directly.

Count Yes/No not blank = CALCULATE(COUNTROWS('Table'), 'Table'[Yes/No] <> "")

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.