https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-the-Count-Distinct/m-p/3721148#M144900 <P>I'm creating a matrix table to find out which country is involved in each Customer transaction.&nbsp;</P><P>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!</P><P><img /></P><P>&nbsp;</P> Sat, 24 Feb 2024 10:29:06 GMT Ger_maine 2024-02-24T10:29:06Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-the-Count-Distinct/m-p/3721148#M144900 <P>I'm creating a matrix table to find out which country is involved in each Customer transaction.&nbsp;</P><P>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!</P><P><img /></P><P>&nbsp;</P> Sat, 24 Feb 2024 10:29:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-the-Count-Distinct/m-p/3721148#M144900 Ger_maine 2024-02-24T10:29:06Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-the-Count-Distinct/m-p/3721195#M144902 <P>Hi,</P> <P>I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.</P> <P>Please check the below picture and the attached pbix file.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Sat, 24 Feb 2024 12:07:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sum-of-the-Count-Distinct/m-p/3721195#M144902 Jihwan_Kim 2024-02-24T12:07:23Z