topic How to count (and get %) of students who met 70% of their tests? in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-count-and-get-of-students-who-met-70-of-their-tests/m-p/4104319#M162871 <P>Hello,</P><P>I have been struggling with this for days and decided to reach out for help.</P><P>I need to get both the total and the percentage of students who met 70% of their math subtests (there are other school subjects in this data set but just trying to keep it simple for the example. I need to see it by "Test" not subtest). Thank you to anyone who may be able to help.</P><P>Here is dummy data:</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>User ID</TD><TD>Result</TD><TD>Test</TD><TD>Subtest</TD></TR><TR><TD>1</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>1</TD><TD>Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>1</TD><TD>Met</TD><TD>Math</TD><TD>Equations</TD></TR><TR><TD>1</TD><TD>Not Met</TD><TD>Math</TD><TD>Word Problems</TD></TR><TR><TD>1</TD><TD>Not Met</TD><TD>Math</TD><TD>Statistics</TD></TR><TR><TD>2</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>2</TD><TD>Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>3</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>3</TD><TD>Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>4</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>4</TD><TD>Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>5</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>5</TD><TD>Not Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>6</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>6</TD><TD>Not Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>7</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>7</TD><TD>Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>7</TD><TD>Met</TD><TD>Math</TD><TD>Equations</TD></TR><TR><TD>7</TD><TD>Met</TD><TD>Math</TD><TD>Word Problems</TD></TR><TR><TD>7</TD><TD>Met</TD><TD>Math</TD><TD>Statistics</TD></TR><TR><TD>8</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>8</TD><TD>Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>9</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>9</TD><TD>Not Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>10</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>10</TD><TD>Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>11</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>11</TD><TD>Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>12</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>12</TD><TD>Not Met</TD><TD>Math</TD><TD>Decimals</TD></TR></TBODY></TABLE> Fri, 16 Aug 2024 13:46:23 GMT afaherty 2024-08-16T13:46:23Z How to count (and get %) of students who met 70% of their tests? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-count-and-get-of-students-who-met-70-of-their-tests/m-p/4104319#M162871 <P>Hello,</P><P>I have been struggling with this for days and decided to reach out for help.</P><P>I need to get both the total and the percentage of students who met 70% of their math subtests (there are other school subjects in this data set but just trying to keep it simple for the example. I need to see it by "Test" not subtest). Thank you to anyone who may be able to help.</P><P>Here is dummy data:</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>User ID</TD><TD>Result</TD><TD>Test</TD><TD>Subtest</TD></TR><TR><TD>1</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>1</TD><TD>Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>1</TD><TD>Met</TD><TD>Math</TD><TD>Equations</TD></TR><TR><TD>1</TD><TD>Not Met</TD><TD>Math</TD><TD>Word Problems</TD></TR><TR><TD>1</TD><TD>Not Met</TD><TD>Math</TD><TD>Statistics</TD></TR><TR><TD>2</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>2</TD><TD>Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>3</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>3</TD><TD>Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>4</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>4</TD><TD>Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>5</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>5</TD><TD>Not Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>6</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>6</TD><TD>Not Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>7</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>7</TD><TD>Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>7</TD><TD>Met</TD><TD>Math</TD><TD>Equations</TD></TR><TR><TD>7</TD><TD>Met</TD><TD>Math</TD><TD>Word Problems</TD></TR><TR><TD>7</TD><TD>Met</TD><TD>Math</TD><TD>Statistics</TD></TR><TR><TD>8</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>8</TD><TD>Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>9</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>9</TD><TD>Not Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>10</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>10</TD><TD>Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>11</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>11</TD><TD>Met</TD><TD>Math</TD><TD>Decimals</TD></TR><TR><TD>12</TD><TD>Met</TD><TD>Math</TD><TD>Fractions</TD></TR><TR><TD>12</TD><TD>Not Met</TD><TD>Math</TD><TD>Decimals</TD></TR></TBODY></TABLE> Fri, 16 Aug 2024 13:46:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-count-and-get-of-students-who-met-70-of-their-tests/m-p/4104319#M162871 afaherty 2024-08-16T13:46:23Z Re: How to count (and get %) of students who met 70% of their tests? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-count-and-get-of-students-who-met-70-of-their-tests/m-p/4104497#M162882 <P><img /></P> <P>&nbsp;</P> Fri, 16 Aug 2024 15:25:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-count-and-get-of-students-who-met-70-of-their-tests/m-p/4104497#M162882 lbendlin 2024-08-16T15:25:11Z Re: How to count (and get %) of students who met 70% of their tests? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-count-and-get-of-students-who-met-70-of-their-tests/m-p/4104547#M162885 <P>Beautiful, thank you!! (I also like the filename "ah the seventies" - made me laugh!)</P> Fri, 16 Aug 2024 15:39:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-count-and-get-of-students-who-met-70-of-their-tests/m-p/4104547#M162885 afaherty 2024-08-16T15:39:10Z