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 Measu...
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"))

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"))