Forum Discussion

gmasta1129's avatar
gmasta1129
Resolver 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
v-xiaosun-msft's avatar
v-xiaosun-msft
Community Support
3 years ago

Hi gmasta1129 ,

 

According to your description, here is my solution.

You can try to implement power bi sumif with the function in dax that is “Calculate”.

I created a sample.

For example, if we want filter "Is Credit Open"="Y" && "Cust. No">2, we can do as followings:

Measure =
IF (
    MAX ( 'Table'[Is Credit Open] ) = "Y",
    CALCULATE ( SUM ( 'Table'[Total Amount] ), 'Table'[Cust No.] > 2 )
)

Final output:

You can set the filter section according to your needs.

 

I attach my sample below for your reference.

 

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.