Forum Discussion

amtbew's avatar
amtbew
Helper I
2 years ago
Solved

Column based on another table

I have the two following tables, connected by Store ID.   Store Proposals Store ID  Proposal  A1  $      500.00 A2  $      700.00 A3  $      350.00     Store Sales Store ...
Need Help
  • Idrissshatila's avatar
    Idrissshatila
    2 years ago

    Hello amtbew ,

     

    try the following

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

     

     

  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Idrissshatila's avatar
Idrissshatila
Super User
2 years ago

Hello amtbew ,

 

try the following

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

 

 

  • amtbew's avatar
    amtbew
    Helper I
    2 years ago

    Thanks @Idrisshalita 

     

    Any alternative to using Countrows? I tried to wrap it in an If statement to produce a true or false but received a circular reference. Hoping to use this column a True/false slicer.