Forum Discussion
How to Build a Particular Measure for Gauge Chart in PowerBI
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!
1 Reply
- amitchandak
Super User
PBIFNG , Try a measure like
Divide( calculate(sum(Table[Value]), filter(Table, Table[Type]= "Won")), sum(Table[Value]))
