Forum Discussion

Olia's avatar
Olia
Icon for Advocate II rankAdvocate II
7 years ago
Solved

DAX formula nesting: SUMIFS + OR

Hi Everyone,   Can anyone please tell me how I can make this work?   JulRFF 2018 = CALCULATE(sum(MGMT_PL_FACT[Sum(AMOUNT)]), MGMT_PL_FACT[VERSION] = "JuLRFF 2018",MGMT_PL_FACT[REPORTING_ITEM.1]="...
Need Help
  • ST's avatar
    ST
    7 years ago

    HI!

     

    try this one mate:

     

    JulRFF 2018 = CALCULATE(sum(MGMT_PL_FACT[Sum(AMOUNT)]), MGMT_PL_FACT[VERSION] = "JuLRFF 2018",MGMT_PL_FACT[REPORTING_ITEM.1]="S&A" || MGMT_PL_FACT[REPORTING_ITEM.1]="FIN")

    I hope it helps :)

ST's avatar
ST
Frequent Visitor
7 years ago

HI!

 

try this one mate:

 

JulRFF 2018 = CALCULATE(sum(MGMT_PL_FACT[Sum(AMOUNT)]), MGMT_PL_FACT[VERSION] = "JuLRFF 2018",MGMT_PL_FACT[REPORTING_ITEM.1]="S&A" || MGMT_PL_FACT[REPORTING_ITEM.1]="FIN")

I hope it helps :)