Forum Discussion

dinoscool3's avatar
dinoscool3
Helper II
4 years ago
Solved

Conditional Column based on other table

I have a table of registrations and a table of viewers. I would try to add them as a relationship but because of how the data is stored and the number of webinars, registrations, and viewers, I can't...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    4 years ago

    dinoscool3 

    Try adding this as a calculated column in your Registrations table.

    Watched = 
VAR _ViewCount = 
CALCULATE (
    COUNTROWS ( Viewers ),
    TREATAS (
        CALCULATETABLE (
            SUMMARIZE ( Registrations, Registrations[Email], Registrations[Webinar] )
        ),
        Viewers[Email],
        Viewers[Webinar]
    )
)
RETURN IF ( _ViewCount > 0, "Yes", "No" )
amitchandak's avatar
amitchandak
Super User
4 years ago

dinoscool3 ,

New column Registration =

var _1 = Maxx(filter(Viewers, Viewers[Email] =Registration[email]), Viewers[Email])

return

if(isblank(_1), "No", "Yes")

dinoscool3's avatar
dinoscool3
Helper II
4 years ago

When I try to do this, I can't add in the registration email in the filter, it only lets me add in values from the viewers table.