# Expression error

[shikhavidyarthi]

I am creating a new custom column for a table with more than 30 columns. 

I am trying to create a new column with IF and ELSE Statement but getting the below error. Please let me know the correct syntax for this.

if [Criteria] = 1 then
(if [override_reason] = "KEEP" then Count[facility_id] else 0)/(count[facility_id]) else 0

[shikhavidyarthi]

Hi,

I want the result as bottom screenshot.

[BA_Pete · Accepted solution]

Ah, ok.

You want to do this in DAX, not in Power Query. Create a DAX measure like this:

_Overr_ct_pct =
VAR __idCount =
COUNT(yourTable[Overr_ct])
VAR __total =
CALCULATE(
    COUNT(yourTable[Overr_ct]),
    REMOVEFILTERS(yourTable),
    VALUES(yourTable[id])
)
RETURN
IF(
    MAX(yourTable[Keep_num]) = 1,  // If [Keep_num] is a measure you can remove the MAX() and 'yourTable' bits
    DIVIDE(__idCount, __total, 0)
)

Select this new measure from the Fields list, go to the Measure Tools tab, change the format to Percent:

Pete

[BA_Pete]

Hi @shikhavidyarthi ,

Assuming I'm understanding what you're trying to do, I think it would look like this:

if [Criteria] = 1 and [override_reason] = "KEEP"
then List.Count(previousStepName[facility_id]) / List.Count(previousStepName[facility_id])
else 0

Pete

[shikhavidyarthi]

If criteria = 1 then ( if override_reason = 'KEEP' then count(facility_id))/Count(facility_id) else 0

[BA_Pete]

Hi @shikhavidyarthi ,

That's what my code does.

If it's not doing what you're expecting it to do, can you give me some more detail around what you need please?

Pete