https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-count-of-multiple-text-in-column-by-the-total-count-of/m-p/2877860#M93041 <P>Hello, i need to create a pass / fail percentage visual. I have column 'A' with different text in the cells that say pass, fail,N/A and blanks. I need to be able to filter by the different text values and divide them by the overall count of the column. Is this possible if not is there a work around?&nbsp;</P> Tue, 01 Nov 2022 17:11:24 GMT A-Aron 2022-11-01T17:11:24Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-count-of-multiple-text-in-column-by-the-total-count-of/m-p/2877860#M93041 <P>Hello, i need to create a pass / fail percentage visual. I have column 'A' with different text in the cells that say pass, fail,N/A and blanks. I need to be able to filter by the different text values and divide them by the overall count of the column. Is this possible if not is there a work around?&nbsp;</P> Tue, 01 Nov 2022 17:11:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-count-of-multiple-text-in-column-by-the-total-count-of/m-p/2877860#M93041 A-Aron 2022-11-01T17:11:24Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-count-of-multiple-text-in-column-by-the-total-count-of/m-p/2877886#M93045 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="417577" data-lia-user-login="A-Aron" class="lia-mention lia-mention-user">A-Aron</a>&nbsp;</P> <P>please try</P> <LI-CODE lang="javascript">% Count = DIVIDE ( COUNTROWS ( 'Table' ), COUNTROWS ( CALCULATETABLE ( 'Table', ALL ( 'Table'[Column] ) ) ) )</LI-CODE> Tue, 01 Nov 2022 17:21:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-count-of-multiple-text-in-column-by-the-total-count-of/m-p/2877886#M93045 tamerj1 2022-11-01T17:21:04Z