Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Filter within calculate does not filter other visual

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...
"CALCULATE"
DAX
Filter context
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.