Forum Discussion

pickslides's avatar
pickslides
Icon for Helper I rankHelper I
4 years ago

Looking up values across different tables

Hi, I have two tables. One is a list of students the other a list of activities. I wish to count (in DAX) the number of distinct activities they have choosen if they are "Co-curirrcular" (Green). I h...
pickslides's avatar
pickslides
Icon for Helper I rankHelper I
4 years ago

A-ha.. I found a typo in the formula. Seems to work now. 

 

If the result is zero, cells are blank, can I populate with 0 somehow?

 

Q

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    pickslides 

    Two questions: do you have relationship between the two tables? Are you creating a calculated coumn in the student table?

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    pickslides 

    Yes you can

    Count =
COUNTROWS (
    FILTER (
        Participation,
        Participation[Category] = "Co-curirrcular"
            && Participation[Preferred] = Sudent[Preferred]
    )
) + 0