Forum Discussion

barragan82's avatar
barragan82
Icon for Helper II rankHelper II
10 months ago
Solved

DAX Measure for a Specific If and Then

Hello, I’m hoping to get help with a DAX measure that can do all of the following. [Assignments]>=110,*.1 (ex. If the sum is 236, multiply by 0.1 to render 23.6) [Assignments]>=10&&[Assignments]<...
Need Help
  • Praful_Potphode's avatar
    Praful_Potphode
    10 months ago

    Hi barragan82  

    Please try below dax measure:

    Measure = 
SUMX (
    SUMMARIZE (
        'Table',
        'Table'[Course],
        "AssignmentsTotal", SUM ( 'Table'[Assignments] )
    ),
    VAR AssignmentsTotal = [AssignmentsTotal]
    var a=    IF(
        AssignmentsTotal>= 110, AssignmentsTotal * .1,
     IF(   AssignmentsTotal >= 10, 10,
   IF(     AssignmentsTotal>= 5, AssignmentsTotal,
        0
    )
)
    )
    RETURN a
)

    Please give Kudos or mark it as solution once confirmed.

     

    Thanks and Regards,

    Praful

Praful_Potphode's avatar
Praful_Potphode
Icon for Super User rankSuper User
10 months ago

Hi barragan82  

Please try below dax measure:

Measure = 
SUMX (
    SUMMARIZE (
        'Table',
        'Table'[Course],
        "AssignmentsTotal", SUM ( 'Table'[Assignments] )
    ),
    VAR AssignmentsTotal = [AssignmentsTotal]
    var a=    IF(
        AssignmentsTotal>= 110, AssignmentsTotal * .1,
     IF(   AssignmentsTotal >= 10, 10,
   IF(     AssignmentsTotal>= 5, AssignmentsTotal,
        0
    )
)
    )
    RETURN a
)

Please give Kudos or mark it as solution once confirmed.

 

Thanks and Regards,

Praful

  • barragan82's avatar
    barragan82
    Icon for Helper II rankHelper II
    10 months ago

    This worked perfectly. Thank you!