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

     

     

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!