Currently I have a measure compliant % that is being calculated:
=IF(ISBLANK(DIVIDE(CALCULATE(COUNT(DC_Scorecard[Value]),DC_Scorecard[Value]="Compliant"),CALCULATE(COUNT(DC_Scorecard[Value]),DC_Scorecard[Value]="Compliant")+CALCULATE(COUNT(DC_Scorecard[Value]),DC_Scorecard[Value]="Not Compliant"),0)),"NA",DIVIDE(CALCULATE(COUNT(DC_Scorecard[Value]),DC_Scorecard[Value]="Compliant"),CALCULATE(COUNT(DC_Scorecard[Value]),DC_Scorecard[Value]="Compliant")+CALCULATE(COUNT(DC_Scorecard[Value]),DC_Scorecard[Value]="Not Compliant"),0))
With this table, result:

I want to change this, so it typically calculates this way but for the metric name "Sup Training / Sales Leadership", I want it to be the sum(Dc numerator)/(DC Demonator).
They are running off the DC Scorecard, this table, showing relevant columns.

Aucun commentaire:
Enregistrer un commentaire