Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Lattelin
Frequent Visitor

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

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

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

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:

vyalanwumsft_0-1625206898461.png

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.

 

View solution in original post

3 REPLIES 3
v-yalanwu-msft
Community Support
Community Support

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:

vyalanwumsft_0-1625206898461.png

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
Not applicable

Hey @Lattelin , i used this measure

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

Postigo_0-1625063295819.png

See if works for you

amitchandak
Super User
Super User

@Lattelin , Assume Discount Percentage is a measure 

 

Try meausre 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.