Dear Power fans, some help here would be greatly appreciated.
Below is a very simplified version of what I'm trying to achieve...
I have two sql tables: PolicyTable and ClaimsTable (see attachment)
The underwriters need to know the Loss Ratio by broker so I've created a new table in PowerBI using the GroupBy function and added a new column to this which divides the total claims per broker by the total earnings per broker.
This is fine but I need to be able to slice this up by year. How can I set up a relationship between BrokerGrouped and PolicyTable so that I can slice by year in the report and the Loss Ratios will adjust
acordingly?
Many thanks
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
