I'm creating a matrix table to find out which country is involved in each Customer transaction.
The values I set are based on Customer - Count (Distinct) - which creates what I want, but the TOTAL is based on Count (Distinct) too. I would like to have the TOTAL = to the sum Count of all countries involved, so I could filter if 2 or 3 countries are involved in each account. Hope anyone could help. Thank you!
Hi,
I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
Hi,
I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - November 2025
Check out the November 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.
