Help calculate "Closed Won" on PowerBi Measure, Simple Formula

[Lattelin]

Hello everyone,

I have a table that looks like the following below (With more rows). I am trying to create a formula with "Modeling - New Measure" to calculate the percent of closed won. I want to do percent = Closed Won / (Closed Lost + Won) in DAX expression. Thanks  🙂

Discount Percentage  Stage Name         

10%                            Closed Lost          

17%                            Closed Won

8%                              Closed Won

11%                            Closed Lost

[v-yalanwu-msft · Accepted solution]

Hi, @Lattelin ;

You could create a measure as follows:

Measure = SUMX(FILTER(ALL('Table'),[Stage Name]="Closed Won"),[Discount Percentage])/SUMX(ALL('Table'),[Discount Percentage])

or

Measure =
DIVIDE (
    SUMX (
        FILTER ( ALL ( 'Table' ), [Stage Name] = "Closed Won" ),
        [Discount Percentage]),
    SUMX ( ALL ( 'Table' ), [Discount Percentage] ))

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hey @Lattelin , i used this measure

Measure = DIVIDE(CALCULATE(COUNTROWS(Tabela),Tabela[Stage Name]="Closed Won"),COUNTROWS(Tabela))

See if works for you

[amitchandak]

@Lattelin , Assume Discount Percentage is a measure 

Try meausre 

divide(calculate([Discount Percentage], filter(Table , Table[Stage Name] = "Closed Won")),
calculate([Discount Percentage]))