Forum Discussion

benvett14's avatar
benvett14
Frequent Visitor
6 years ago

Formula Help (compliance %)

I am trying to create a measure that will give me a compliance % based on dates. The column highlighted (date) in the table below are my "completed dates", (the dates that complaince requirements wer...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi benvett14 

 

You can try this.

 

 

 

 

Complaince Percent =

var a = COUNTROWS(ALL('Date'[Date]))
var b = CALCULATE(DISTINCTCOUNT('Table'[Completed Date]),ALLSELECTED('Table'[Completed Date]))
RETURN
DIVIDE(b,a)
 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)