need count with respect to name in table visual

[ppatil]

Hi Community..!!
Need quick response..!!

I need to count supplier count and order count with respect to shop name. But in the above table visual all values are repeating. supplier and order is present in table1 and shop name is present in table2.
will u please help me to solve this..!!

[Nathaniel_C]

Hi @ppatil , will you show us a picture of the relationship between these two tables?
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[ppatil]

Order ---> Shop
one to many (1-*)

[v-rzhou-msft · Accepted solution]

Hi @ppatil ,

According to your statementm, [Supplier] and [Order] in same table, [Shop] in the second table and you relate two tables by Table1[Order] and Table2[Shop]. The relationship is one to many (1-*).

You create a table visual by Table2[Shop], Table1[Order] and Table1[Supplier]. As far as I know, if you create a relationship as you mentioned above, Power BI should show you correct result.

My Sample is as below.

Table1:

Table2:

Relationship:

Result is as below.

Please check your relationship. Or you can try to create measures to count Supplier and Order.

Count of Supplier =
CALCULATE (
    COUNT ( 'Table1'[Supplier] ),
    FILTER ( 'Table1', 'Table1'[Column Related to Table2] = MAX ( 'Table2'[Shop] ) )
)

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ppatil]

Thank U @v-rzhou-msft