Help with my relationship between tables

[Francease]

I have two tables 1. All Games 2. Register
Im doing two reports 1. Daily report 2. Agent report

When I put the relationship on both tables on my transaction_date my daily report is all working perfectly but my agent report is not. 

The problem in my agent report is that it is not getting all the agent names and dispalying a blank agent name.

When I put the relationship on both tables on my username(all games) and customer_name(register), now all of my agent names are showing but the registered count is not. 

how can i fix this so that both reports are dispalying correctly?

[Anonymous · Accepted solution]

Hi @Francease ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data. 

(2) We can create a date table and then create model relationships.

Date = CALENDAR(DATE(2024,1,1),DATE(2024,12,31))

(3) We can create a measure.

Measure = COUNTROWS(FILTER('Register','Register'[transaction_date]=MAX('Date'[Date])))

(4) Then the result is as follows.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

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

[Wilson_]

Hi Francease,

Can you please share a model pbix and/or a screenshot of the model view? (If you don't know how, please check the pinned thread in the forum.) It would make debugging your issue easier. 🙂

[AnalyticPulse]

you need to create a relationship between the two tables, relationship doesnt exist between these two tables thats why your report is showing same values for all customer name.
you are using two different feilds from two different tables. 
create a relationship based on column which has relationships link. like foreign key and primary key.

My blog:
https://analyticpulse.blogspot.com/2024/03/superstore-sales-2022-vs-2023-year-on.html
https://analyticpulse.blogspot.com/
https://analyticpulse.blogspot.com/2024/04/case-study-powerbi-dashboard-developer.html

See my Pins :
https://pin.it/5aoqgZUft
https://in.pinterest.com/AnalyticPulse/