cancel
Showing results for
Did you mean:

## formula dax

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
1 ACCEPTED SOLUTION
Super User

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.

Super User

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.

Announcements