Forum Discussion

Hudg16's avatar
Hudg16
Helper I
4 years ago
Solved

Counting Text between two tables

I have the following tables: I want to count new/upgrade for each dealer. The expected result would be 2 new for Jump.cam however, when I use this formula: New = calculate(count(...
  • HotChilli's avatar
    4 years ago

    There's no relationship between the two tables.  As a human, you can see that e.g. Bolt Mobile is in both tables but powerbi can't.

    Options: Either use the top table (above) as a dimension table (with relationship 1:m to DLR)

    OR

    use all fields in visual from the lower table (with your measure) as that should work