Forum Discussion
Administratorformula 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 |
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.
1 Reply
- jdbuchanan71
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.