desktop

[renugiri]

Hi,

I have multiple tables with common columns, with the following details,

Table1: with columns--> Uid,UName,DOB

Table2: with columns-->UID,datecreated,Lastupdated


Now My case is,


 case1 :select Uid from Table1 where uid in (select uid from Table2);

case2: select Uid from Table1 where uid in (select uid from Table2);


What i DO need:

with the above results, i need a new MEASURE with the results of case1 as paired, with results of case2 as not paired

Can Anyone help me to create a NEW MEASURE

Regards,

Giri

[v-yulgu-msft]

Hi @renugiri,

Please elaborate your requirement with some examples. Please provide images which can better show your report design and expected output. It's hard to imagine what measure you want and what does "with the results of case1 as paired, with results of case2 as not paired" mean.

Best regards,
Yuliana Gu