https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-rows-per-value-in-field/m-p/675109#M385 <P>&nbsp;</P><P>Hi, Community.</P><P>&nbsp;</P><P>I am facing the following challenge and I hope you are able to help me. My data set contains a column that on a field could contain various values.</P><P>&nbsp;</P><P>What I want to achieve is to have a measure that counts every time a country appear listed in the Country column. Ex:</P><P>&nbsp;</P><P>Lebanon 2</P><P>Pakistan 2</P><P>Saudi Arabia 1</P><P>Algeria 1</P><P>Burkina Faso 1&nbsp;</P><P>Cameroon 1</P><P>&nbsp;</P><P>etc.</P><P>&nbsp;</P><P>Have you encountered this? Any recommendations?</P><P>&nbsp;</P><P>Thank you in advance!</P><P>&nbsp;</P><P><img /></P> Mon, 22 Apr 2019 20:36:52 GMT Anonymous 2019-04-22T20:36:52Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-rows-per-value-in-field/m-p/675109#M385 <P>&nbsp;</P><P>Hi, Community.</P><P>&nbsp;</P><P>I am facing the following challenge and I hope you are able to help me. My data set contains a column that on a field could contain various values.</P><P>&nbsp;</P><P>What I want to achieve is to have a measure that counts every time a country appear listed in the Country column. Ex:</P><P>&nbsp;</P><P>Lebanon 2</P><P>Pakistan 2</P><P>Saudi Arabia 1</P><P>Algeria 1</P><P>Burkina Faso 1&nbsp;</P><P>Cameroon 1</P><P>&nbsp;</P><P>etc.</P><P>&nbsp;</P><P>Have you encountered this? Any recommendations?</P><P>&nbsp;</P><P>Thank you in advance!</P><P>&nbsp;</P><P><img /></P> Mon, 22 Apr 2019 20:36:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Count-rows-per-value-in-field/m-p/675109#M385 Anonymous 2019-04-22T20:36:52Z