Forum Discussion

geekmachine811's avatar
geekmachine811
Frequent Visitor
3 years ago
Solved

DAX Measure with multiple FILTER Criteria

Hello,

I am trying to formulate a formula that would sum various fields based on a criteria. However, within the same measure, the summation formula is different.

 

I have tried creating the Measure below but it has errors.

Target2 = CALCULATE(SUMX(CAC_CLIENT_ACCOUNTING_FILE,[Below60Sum]*0.75 + [Above60Sum]*0.5 + [Above366Sum]*0.1),
                    FILTER(Divisions,Divisions[Div 2]="Healthcare" || Divisions[Div 2]="Life" || Divisions[Div 2]="Pensions" || Divisions[Div 2]="Wellness Consulting"),
                    SUMX(CAC_CLIENT_ACCOUNTING_FILE,[Below60Sum]*0.75 + [Above60Sum] * 0.5),
                    FILTER(Divisions,Divisions[Div 2]="Medical Managed Care"))
 
From above, you can see that the Div2="Medical Managed Care" has a different formula than the rest.

I need it in one formula because the data is posted in a Matrix Visual.

 

Any help would be appreciated
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    3 years ago

    geekmachine811 , There are two measures in this , you need add them or divide

     

    CALCULATE(SUMX(CAC_CLIENT_ACCOUNTING_FILE,[Below60Sum]*0.75 + [Above60Sum]*0.5 + [Above366Sum]*0.1),
    FILTER(Divisions,Divisions[Div 2]="Healthcare" || Divisions[Div 2]="Life" || Divisions[Div 2]="Pensions" || Divisions[Div 2]="Wellness Consulting") )


    CALCULATE(SUMX(CAC_CLIENT_ACCOUNTING_FILE,[Below60Sum]*0.75 + [Above60Sum] * 0.5),
    FILTER(Divisions,Divisions[Div 2]="Medical Managed Care"))

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    geekmachine811 , There are two measures in this , you need add them or divide

     

    CALCULATE(SUMX(CAC_CLIENT_ACCOUNTING_FILE,[Below60Sum]*0.75 + [Above60Sum]*0.5 + [Above366Sum]*0.1),
    FILTER(Divisions,Divisions[Div 2]="Healthcare" || Divisions[Div 2]="Life" || Divisions[Div 2]="Pensions" || Divisions[Div 2]="Wellness Consulting") )


    CALCULATE(SUMX(CAC_CLIENT_ACCOUNTING_FILE,[Below60Sum]*0.75 + [Above60Sum] * 0.5),
    FILTER(Divisions,Divisions[Div 2]="Medical Managed Care"))