Hide row if at least one value is blank

[dax_rach]

Hello everyone, if someone could please give me a hand with the issue I've come across?
This matrix is to compare client against any other competitor, and they are being compared based on keywords. So the main idea is:
-When we have client (that has data in all keywords) and a competitor (with no data in some keywords). I need to hide the enrire row when there's a blank value for the competitor. So the calculation is done based on the shown rows with data.

I appreciate any idea on this matter, thanks!

[some_bih]

Hi @dax_rach in your pivottable, column keywords is from your fact or dimension table? try to switch it.