mardi 20 octobre 2020

Conditional Measure Calculation

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:

enter image description here

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.

enter image description here

Aucun commentaire:

Enregistrer un commentaire