How to have 2 condition columns result

[abeerq]

Dears, 

I'm looking for your usual support as I am facing an issue on how to do the measure what i need as below: 

I want to do a KPI measurement on how many change request dose the project number has if it has 3 or less than CR ID it would be within target if other than this would be below target so the comparing between ( Project Number and CR ID) 

Kindly advise me in this matter

[Anonymous · Accepted solution]

HI @abeerq ,

Please try to use following measure if it works for your requirement:

Measure =
VAR currID =
    SELECTEDVALUE ( Table[CR ID] )
VAR currCount =
    COUNT ( table[Project] )
RETURN
    IF (
        currCount = 3
            || currCount < currID,
        "Within",
        DIVIDE ( currCount, currID, 0 )
    )

If above not help, please share some sample data and expected result for test.

Regards,

Xiaoxin Sheng