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.
