Forum Discussion
Solved
Calculating Values By Contract By Country From Multiple Tables
Hi, I am trying to produce a table that will report the number of contracts that my company has in each country by reference. This is complicated slightly by the the fact that I am using multip...
You can do a relationship by using the two columns country and company reference
You can create a relationship and then add
create a simle DAX measures for No.ofPolicies
No of Policies = SUM(Table[No of Policies])Create a table visual and bring the Underwriter Ref & RiskCountry columns and the above measure into it.
Connect on LinkedIn
|
Hi, thank you for your suggestion. I am now closer but I still have an issue so the measure may need some tweaking.
Company Ref RiskCountry 4,576 ref1AA Canada 11 ref1AA Singapore 11 ref1AA South Africa 11 ref1AA Taiwan 11 ref1AA United Arab Emirates 11 ref1AA United States 11 ref1AG United States 9 ref1AK Canada 3,876 ref1AM United States 180 ref1AN United States 499 ref1AQ United States 1 Total 4,631 Thank you in advance.
