Forum Discussion

gmasta1129's avatar
gmasta1129
Icon for Resolver I rankResolver I
3 years ago

Sum if Formula

Hello,   I have the following columns in my report:   Cust No. Total Amount Is Credit Open       I need to produce the following formula in Power BI desktop...   If(Is Credit Open = "Y",S...
Need Help
gmasta1129's avatar
gmasta1129
Icon for Resolver I rankResolver I
3 years ago

Thank you for the quick response but unfortunately neither of the formulas worked.. 

Please see below highlighted column for result I am looking for.  I want to sum the total amount by cust. no and only the rows that contain a Y in Is Credit Open

 

 

  • Thennarasu_R's avatar
    Thennarasu_R
    Icon for Responsive Resident rankResponsive Resident
    3 years ago

    Measure=
                   Calculate(Total Amount,ISCredit="Y")