Solved: Counting Text between two tables

Hudg16 · ‎10-06-2021

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(Activation[New/Upgrade]),Activation[New/Upgrade]="New")
I merely get a total of 4.

Any suggestions? Here is my pbix: https://we.tl/t-znJfXvHnQk
Thanks guys.

HotChilli · ‎10-06-2021

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 · ‎10-06-2021

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

Counting Text between two tables