Forum Discussion
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...
Hi gmasta1129
You need a measure, but how do you want to use that measure in your report? Do you want to use that in a table that has "Cust No."? if yes, try this:
Measure =
CALCULATE (
SUM ( Table[Total Amount] ),
KEEPFILTERS ( Table[Credit Open] = "Y" )
)
On the other hand, You can add Cust. No and total Amount to your visual and then use Credit Open in the filter pane and set that to show the Y values only.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn | Twitter | Blog | YouTube