Conditional Calculate

[CLEARIFY]

I realize you cannot do a simple IF statement like in regular Excel.

Goal:
A field in a dimension has a 'Y' or 'N'.
If it says 'Y' then: 100
If it says 'N' then: CALCULATE(DIVIDE([Job Line Costs To Date],SUM('JOB COST DETAILS'[Job Line Estimate Cost Amount])),Job[Job Comp Y or N]="N")

 

[ca.moazzam]

Hi pls give some sample data to explain your question

 

[CLEARIFY]

Hi pls give some sample data to explain your question

Trying not to make it complicated.
(a) One column as Y or N as possible outcomes in a dimension field
(b) One FACT column - Job Estimate Amount
(c) One FACT column - Job Cost Amount

Simple desired result:

If column (a) has a 'Y' then result is 100
If column (a) has a 'N' then divide (b) by (c)