Add to existing formula for new result

[cbouichi]

I recieved a file with this formula:

KPI 2 (%) = IF(COUNTROWS(FILTER(Projectstatus; Projectstatus[Binnen planning opgeleverd? (KPI 2)] = "Ja"))=0;0; COUNTROWS(FILTER(Projectstatus; Projectstatus[Binnen planning opgeleverd? (KPI 2)] = "Ja"))) / [Totaal Aantal Actieve Projecten]

I want to add a formula that if the answer is "Nee" that wil result in a negatieve counting %.

Im learning alot thx too you guys.

[v-chuncz-msft]

@cbouichi,

You may refer to the DAX below.

Measure =
- (
    COUNTROWS (
        FILTER (
            Projectstatus;
            Projectstatus[Binnen planning opgeleverd? (KPI 2)] = "Nee"
        )
    )
        + 0
)
    / [Totaal Aantal Actieve Projecten]

[cbouichi]

i copied your dax. it still is 100%

KPI 2 (%) = IF(COUNTROWS(FILTER(Projectstatus; Projectstatus[Binnen planning opgeleverd? (KPI 2)] = "Ja"))=0;0; COUNTROWS(FILTER(Projectstatus; Projectstatus[Binnen planning opgeleverd? (KPI 2)] = "Ja"))) / [Totaal Aantal Actieve Projecten]- (
    COUNTROWS (
        FILTER (
            Projectstatus;
            Projectstatus[Binnen planning opgeleverd? (KPI 2)] = "Nee"
        )
    )
        + 0
)
    / [Totaal Aantal Actieve Projecten]

What im doing wrong?

[v-chuncz-msft]

@cbouichi,

Show us a complete example and the expected output.