In straight table have rows show only when two conditions are met in one column

[tlegit]

Hello, This is my first post so bare with me. 

I have a requirement to show only clients that have both an Over/Under associated in the Visit Target column like this:

Client	Payor	Plan	Svc	VisitMonth	AuthHours	VisitHours	VisitTarget	Provisional
A	A	A	ADT	04/01/2022	15	10	Under	No
B	C	C	CL B	04/01/2022	20	5	Under	Yes
C	B	B	RE	04/01/2022	10	0	Under	No
C	B	B	HM	04/01/2022	2	2	Even	Yes
E	A	A	CL B	04/01/2022	0	0	Under	Yes
E	A	A	RE	04/01/2022	25	48.15	Over	No
E	A	A	ADT	04/01/2022	1	0	Under	No

All other records need to be ignored if the client does not have a Under AND Over.

How can I go about this? I have tried set analysis, if statements, match, and other functions but I can't figure it out. I have also searched the forum and googled quite a bit, but wasn't able to find a solution. If it helps, from what I can tell based off my data-- the Svc seems to always be distinct for the Over result compared to the other VisitTargets.

[tlegit]

I was unable to get this to work, Can you provide your solution based off the field Client as an if statement?

Instead of the client field I need --

$(vOPFClient) = IF(MultAuthFlag=1,Client,NULL())

[vinieme12]

For testing just do this 

$(vOPFClient)   ='Client' 

What is MultAuthFlag? Field or variable?

I've been assuming this a variable that you toggle

You cannot have a calculated dimension on the left side of the = in set analysis

If you want to limit Client values in the chart  then you need to add a calculated dimension in the chart and not in set analysis 

Chart Dimension

=Aggr(if(MultAuthFlag=1,Client,null()),Client)

<< Uncheck include null values for this dimension

Measure

= sum({<Client=p({<VisitTarget={'Under'}>}Client)>*<Client=p({<VisitTarget={'Over'}>}Client)>}VisitHours)

[tlegit]

Thanks! This one worked!