Forum Discussion

hushpuppies's avatar
hushpuppies
Frequent Visitor
2 years ago
Solved

Need help with measure

Hi PowerBI Experts!   Here's the current measure for "Remark"   If(isblank(Sum(PS_Financials[CurrentBudget])), if( Sum(PS_Financials[Actual]) > 15000,"At Risk",if( Sum(PS_Financials[Actual]) > 0,...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    Hi hushpuppies

     

    Your  first condition says that SUM ( PS_Financials[CurrentBudget] ) must be blank before proceeding to the next.  However, the row in question is showing  zero. Try changing  ISBLANK ( SUM ( PS_Financials[CurrentBudget] ) ) to ISBLANK ( SUM ( PS_Financials[CurrentBudget] ) ) || SUM ( PS_Financials[CurrentBudget] )  = 0

danextian's avatar
danextian
Icon for Super User rankSuper User
2 years ago

Hi hushpuppies

 

Your  first condition says that SUM ( PS_Financials[CurrentBudget] ) must be blank before proceeding to the next.  However, the row in question is showing  zero. Try changing  ISBLANK ( SUM ( PS_Financials[CurrentBudget] ) ) to ISBLANK ( SUM ( PS_Financials[CurrentBudget] ) ) || SUM ( PS_Financials[CurrentBudget] )  = 0