formula dax

[Syndicate_Admin]

Well, I need a formula to solve this problem.

As you observe I have a number of customers, these in terms of rate have two options that have group rate or what have customer rate, you can realize the case that has both, always imposes the customer rate.

As for the idem discount, you may notice that they have the two columns reported (Dcto group and Dcto customer), always prevailing the dcto customer.

In addition it can happen that a customer has rate group and dcto customer and also that a customer has customer rate and dcto group.

customer	group rate	Customer rate	Dcto Group	Dcto client	result
1	5	0	1	0	4
2	0	5	0	1	4
3	5	0	0	2	3
4	0	5	2	0	3
5	5	3	2	0	1
6	5	3	0	2	1
7	5	3	2	1	2

[jdbuchanan71 · Accepted solution]

@Syndicate_Admin 

Not sure this is what you are looking for.

Rate = 
IF (
    NOT ISINSCOPE ( 'Table'[customer] ),
    BLANK (),
    SUMX (
        'Table',
        IF ( 'Table'[Customer rate] = 0, 'Table'[group rate], 'Table'[Customer rate] )
    )
)

Dcto = 
IF (
    NOT ISINSCOPE ( 'Table'[customer] ),
    BLANK (),
    SUMX (
        'Table',
        IF ( 'Table'[Dcto client] = 0, 'Table'[Dcto Group], 'Table'[Dcto client] )
    )
)

If this is not what you are looking for please provide an example of the expected output and logic for how you got it.