Forum Discussion
Hudg16
4 years agoHelper I
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(...
- 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
HotChilli
4 years agoCommunity Champion
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