Forum Discussion
Power BI Data Model query
I am not understanding how to connect these two tables in data model.
Because of this I am unable to do the report. I am getting error as two tables are not related.
Can you tell me which fields to connect and how? what should be the cardinality and cross filter direction?
Dataset link=
Dashboard Requirements:
1. Broker Performance Tables:
- Construct "Top 10 Brokers" tables based on Gross Written Premium (GWP) for Open Market, Facilities, and Combined, in the 'Broker Stats' tab.
- Incorporate a new column showing the difference between actual and planned GWP as a percentage of the planned GWP.
3. Business Class Analysis Table:
- Using the 'Class Stats' tab, design a table showcasing Planned Premium, Earned Premium, and GWP for various business classes.
- Add columns to display Earned Premium and GWP as percentages of Planned Premium.
The onlly way ou can 'link' these 2 data sets is by putting a date table between them and that would be on the year so you would link both tables to a new table, a date table and that would need to be on the year column. That would be the only way you can bring these 2 datasets together and bring the stats together on year.
However what you haven't provided and in order to give a solution you would need to say say how you would expect this to behave on the page.
as far as i can see the only way to 'join' this data is via the data but if you filter on anything else in either of the tables you might not get expected results.
very simply i have just applied top 10 to each measure so on the visual on each measure you can do something like this on the filter pane on the right
however, not entirely sure what you are expecting to do this this join
see pbix attached
1 Reply
The onlly way ou can 'link' these 2 data sets is by putting a date table between them and that would be on the year so you would link both tables to a new table, a date table and that would need to be on the year column. That would be the only way you can bring these 2 datasets together and bring the stats together on year.
However what you haven't provided and in order to give a solution you would need to say say how you would expect this to behave on the page.
as far as i can see the only way to 'join' this data is via the data but if you filter on anything else in either of the tables you might not get expected results.
very simply i have just applied top 10 to each measure so on the visual on each measure you can do something like this on the filter pane on the right
however, not entirely sure what you are expecting to do this this join
see pbix attached