Solved: Re: need dax to bring back filled % of total reque...

Dougers1 · ‎11-25-2023

Hi

how do i get the filled percentage of substantive againts total requests

Substantive Filled = CALCULATE(COUNTROWS('Export'), 'Export'[Status] = "Substantive Filled")

Total Face to Face Requests = COUNTROWS('Export')

Fowmy · ‎11-25-2023

Percentage of Total = 
DIVIDE ( 
 [Substantive Filled],
 [Total Face to Face Requests]
)

Did I answer your question? Mark my post as a solution! and hit thumbs up

Fowmy · ‎11-25-2023

Percentage of Total = 
DIVIDE ( 
 [Substantive Filled],
 [Total Face to Face Requests]
)

Did I answer your question? Mark my post as a solution! and hit thumbs up

need dax to bring back filled % of total requests