https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/need-dax-to-bring-back-filled-of-total-requests/m-p/3551990#M136667 <P>Hi</P><P>&nbsp;how do i get the filled percentage&nbsp; of substantive againts total requests</P><P>&nbsp;</P><P>Substantive Filled = CALCULATE(COUNTROWS('Export'), 'Export'[Status] = "Substantive Filled")</P><P>Total Face to Face Requests = COUNTROWS('Export')</P> Sat, 25 Nov 2023 13:01:00 GMT Dougers1 2023-11-25T13:01:00Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/need-dax-to-bring-back-filled-of-total-requests/m-p/3551990#M136667 <P>Hi</P><P>&nbsp;how do i get the filled percentage&nbsp; of substantive againts total requests</P><P>&nbsp;</P><P>Substantive Filled = CALCULATE(COUNTROWS('Export'), 'Export'[Status] = "Substantive Filled")</P><P>Total Face to Face Requests = COUNTROWS('Export')</P> Sat, 25 Nov 2023 13:01:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/need-dax-to-bring-back-filled-of-total-requests/m-p/3551990#M136667 Dougers1 2023-11-25T13:01:00Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/need-dax-to-bring-back-filled-of-total-requests/m-p/3552016#M136668 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="635954" data-lia-user-login="Dougers1" class="lia-mention lia-mention-user">Dougers1</a>&nbsp;<BR /><BR /></P> <LI-CODE lang="markup">Percentage of Total = DIVIDE ( [Substantive Filled], [Total Face to Face Requests] ) </LI-CODE> Sat, 25 Nov 2023 14:28:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/need-dax-to-bring-back-filled-of-total-requests/m-p/3552016#M136668 Fowmy 2023-11-25T14:28:34Z