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(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. 

 

 

Need Help
  • HotChilli's avatar
    HotChilli
    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

1 Reply

  • HotChilli's avatar
    HotChilli
    Community Champion
    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