cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Olia Member
Member

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]="S&A" or "FIN")

1 ACCEPTED SOLUTION

Accepted Solutions
ST Frequent Visitor
Frequent Visitor

Re: DAX formula nesting: SUMIFS + OR

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 Smiley Happy

1 REPLY 1
ST Frequent Visitor
Frequent Visitor

Re: DAX formula nesting: SUMIFS + OR

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 Smiley Happy