Quick help with a Custom Measure for Close Percentage based on a sum of 3 separate columns

[Anonymous]

Hi all!  Need help with a quick DAX formula for creating a custom measure for Close Percentage based on 3 separate columns in a data set. I want to use the custom measure as a Line in a Line & Stacked Column Chart. The lead columns are...

IsSoldCount

IsOppCount

IsNotSoldCount

What I'm trying to accomplish: SUM(IsSoldCount) / SUM(IsSoldCount + IsOppCount + IsNotSoldCount) and show this as a percentage.

Can someone help?  Thanks!

[amitchandak]

try

divide(SUM(IsSoldCount), SUMX(table1,IsSoldCount + IsOppCount + IsNotSoldCount))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Nathaniel_C · Accepted solution]

Hi @Anonymous ,
Try this. Put your table name and column names into this measure. Go to the Modeling tab and select Percentage.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

m1 = divide(SUM(test[Column1]),SUM(test[Column1])+SUM(test[Column2])+SUM(test[Column3]))