cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

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.

customergroup rateCustomer rateDcto Group Dcto clientresult
150104
205014
350023
405203
553201
653021
753212
1 ACCEPTED SOLUTION
jdbuchanan71
Super User II
Super User II

@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] )
    )
)

jdbuchanan71_0-1623081105993.png

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

 

 

View solution in original post

1 REPLY 1
jdbuchanan71
Super User II
Super User II

@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] )
    )
)

jdbuchanan71_0-1623081105993.png

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

 

 

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors