IF ELSE in measure using DAX

[Anonymous]

Dear All,

I have the folllwing situation:

I want to create a measure showing the result of two types of margins. Depending on the type of product, a certain margin percentage applies. I have simplyfied the sitution below:

The result should be a measure (in red) and is making use of a margin scheme which can be hardcoded in DAX. The margin scheme isn't a separate table,; it's just published to show the margin percentages used.

I am think to make use of a IF ELSE forumlua within DAX. Any other suggestion / solution is welcome.

Thanks!

[SpartaBI · Accepted solution]

@Anonymous create this caclulated column:

Result = 
'Table'[price] * IF('Table'[Type = "Normal", 0.1, 0.2)

      

Showcase Report – Contoso By SpartaBI

[Anonymous]

Thanks again for your prossible solution.

However, when I run this formula, I get the message that I need to aggregate with Minimum, Maximum, Nummber of Sum function on field 'Table[Type]'. How can I solve this?

Thanks!

[SpartaBI]

@Anonymous hey, just to make sure, cause I missed a columm bracket there, you tried:
Result =
'Table'[price] * IF('Table'[Type] = "Normal", 0.1, 0.2)
And you got that message?
That means you try to create a visaul and not a calculated column.
Try:
Result =
SUMX(
'Table',
'Table'[price] * IF('Table'[Type] = "Normal", 0.1, 0.2)
)

      

Showcase Report – Contoso By SpartaBI

[Anonymous]

Thanks a lot for this additional suggestion.

However when I use this forumla, I still get a message that column / field  [Type]  in table 'Table'  cannot be found, but this field is a field / column in table 'Table'.

Thanks for any additional suggestion

[SpartaBI]

@Anonymous hey, will PM you now