Forum Discussion

ntravis's avatar
ntravis
Frequent Visitor
10 years ago
Solved

Excel user sumif problem in DAX

I am having trouble with the CALCULATE function currently.  I am a heavy Excel user that is trying to transition into Power BI and DAX to further my analytical capabilities.   Given the two tables be...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    ntravis This should work... Let me know...

     

    Revenue =
CALCULATE ( SUM ( Estimate[Amount] ), Estimate[Type] = "R" )
    + CALCULATE ( SUM ( Adjustments[Amount] ), Adjustments[Type] = "R" )

     

     

ntravis's avatar
ntravis
Frequent Visitor
10 years ago

Hi Sean,

 

Yes sorry, both of these tables are transaction tables that are related though a "Job Master" table, where there is one to many relationship that is flows in both directions.

 

Sean's avatar
Sean
Community Champion
10 years ago

ntravis This should work... Let me know...

 

Revenue =
CALCULATE ( SUM ( Estimate[Amount] ), Estimate[Type] = "R" )
    + CALCULATE ( SUM ( Adjustments[Amount] ), Adjustments[Type] = "R" )

 

 

  • ntravis's avatar
    ntravis
    Frequent Visitor
    10 years ago

    Thanks Sean!