Column based on another table

Hello amtbew ,

try the following

Column = CALCULATE(COUNTROWS('Store Sales'),'Store Sales'[Sale Type] = "In Scope")

Hi amtbew ,

If you want to put the result in the if function for judgment, just change the expression to:

InScopeSalesExists =
IF(
CALCULATE(
COUNTROWS('Store Sales'),
'Store Sales'[Sale Type] = "In Scope"
) > 0,
"Yes",
"No"
)

The final result is shown below.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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