Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

calculation help

i have two tables,   Table1  and  Table2  as below. Table1 have 'User' and 'Email' columns.  Each  User will have multiple 'Email' s associated with them. Table2 have 'Msg_ID', 'SenderEmail', 'Re...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    7 years ago

    Hi Anonymous ,

    I create a sample using measures you can reference.

    Measure = var s = VALUES(Table2[SenderEmail])
var r = VALUES(Table2[ReceiverEmail])
return
IF(MAX(Table1[Email]) in s || MAX(Table1[Email]) in r, 0,1)
    Measure 2 =
VAR countr =
CALCULATE ( COUNTROWS ( Table1 ), ALLEXCEPT ( Table1, Table1[User] ) )
VAR ck =
CALCULATE (
COUNTROWS ( Table1 ),
FILTER ( ALLEXCEPT ( Table1, Table1[User] ), [Measure] = 1 )
)
RETURN
IF ( countr = ck, VALUES(Table1[User]), 0 )

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xuding-msft's avatar
v-xuding-msft
Community Support
7 years ago

Hi Anonymous ,

I create a sample using measures you can reference.

Measure = var s = VALUES(Table2[SenderEmail])
var r = VALUES(Table2[ReceiverEmail])
return
IF(MAX(Table1[Email]) in s || MAX(Table1[Email]) in r, 0,1)
Measure 2 =
VAR countr =
CALCULATE ( COUNTROWS ( Table1 ), ALLEXCEPT ( Table1, Table1[User] ) )
VAR ck =
CALCULATE (
COUNTROWS ( Table1 ),
FILTER ( ALLEXCEPT ( Table1, Table1[User] ), [Measure] = 1 )
)
RETURN
IF ( countr = ck, VALUES(Table1[User]), 0 )

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.