How to Build a Particular Measure for Gauge Chart in PowerBI

[PBIFNG]

Hi,

I would like for my Gauge chart to display a percentage as a calculation from another two Values.

Value 1: Stage from a picklist (multiple stages, but I'm interested only in "Won" or "Lost")

Value 2: Dollar value assigned to each record under the various stages

Desired measure:   $ for all "Won" records / ($ for all "Won" + $ for all "Lost") = %

Example:

Record 1 - $50 - Lost

Record 2 - $30 - Won

Record 3 - $60 - Won

Total for all records = $140

Total Won = $90

Desired Calculation: $ total Won/($ total Won + $ total Lost)  = 64%

How would I accomplish this?

Thank you for the help in advance!

[amitchandak]

@PBIFNG ,  Try a measure like

Divide( calculate(sum(Table[Value]), filter(Table, Table[Type]= "Won")), sum(Table[Value]))