Forum Discussion

STYLER44's avatar
STYLER44
Regular Visitor
9 years ago
Solved

How to do a calculation formula with multiple filters

Hi! I am learning Power Bi and I usually use a SUMIFS statement: I have 2 data tables this is what I want it to read: Bring back units booked if season = season column,, na planning org = na planning...
Need Help
  • STYLER44's avatar
    STYLER44
    9 years ago

    Hi! Thank you for the response. My origional questions was confusing... What I needed to do is build more relationships. After I did that I was able to do a simple formula to bring in another data source.

     

    Thank you!

STYLER44's avatar
STYLER44
Regular Visitor
9 years ago

This is how I would write the formula:

 

 =IFERROR(SUMIFS('[BY18 MASTER FILE.xlsx]BOOKINGS_DATA'!$AT:$AT,'[BY18 MASTER FILE.xlsx]BOOKINGS_DATA'!$B:$B,$B2,'[BY18 MASTER FILE.xlsx]BOOKINGS_DATA'!$G:$G,$C2,'[BY18 MASTER FILE.xlsx]BOOKINGS_DATA'!$K:$K,$D2,'[BY18 MASTER FILE.xlsx]BOOKINGS_DATA'!$J:$J,$E2),0)

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago
STYLER44 wrote:

This is how I would write the formula:

 

 =IFERROR(SUMIFS('[BY18 MASTER FILE.xlsx]BOOKINGS_DATA'!$AT:$AT,'[BY18 MASTER FILE.xlsx]BOOKINGS_DATA'!$B:$B,$B2,'[BY18 MASTER FILE.xlsx]BOOKINGS_DATA'!$G:$G,$C2,'[BY18 MASTER FILE.xlsx]BOOKINGS_DATA'!$K:$K,$D2,'[BY18 MASTER FILE.xlsx]BOOKINGS_DATA'!$J:$J,$E2),0)

There's no SUMIF in Power BI, as a workaround you can try

 

total =
SUMX ( FILTER ( YourTable, 1 = 1 && 2 = 2 && moreconditions), valueFiled )