Is it Possible to Filter a Dimension by Set Analysis

[niha]

Hello,

I have a Table like below. All are dimension. I want to see only Unknown PCP Blended Group Practice Name. That mean I only want to see the member number that has unknown Practice Name. Please suggest.

[Vegar · Accepted solution]

For the chart above I used this script/data

Load * inline [
Practice name, Blended group, Member number
My doctor, M123, A123
Your doctor, Y123, A234
UNKNOWN, U123, A345
UNKNOWN, o, A456
];

And this calculated dimension

=IF(match([Practice name], 'UNKNOWN')= 0, [Practice name])

[niha · Accepted solution]

Hello,
We are getting there! I need to show unknown only. I mean the member Having no PCP or unknown. So in Practice Name there should be unknown only.
Thanks

[ajaykakkar93 · Accepted solution]

=IF(match([Practice name], 'UNKNOWN')<> 0, [Practice name])