How to Build a Particular Measure for Gauge Chart in PowerBI

AnnaS 0 Reputation points
2023-07-27T18:12:19.1+00:00

Hi,

I would like for my Gauge chart to display value that's a calculation from another two Values.

Value 1: Stage - binary - "Won" or "Lost"

Value 2: Dollar value associated with each individual record under those stages

Desired calculation: Dollar Value for all "Won" records as a percentage of the Total Dollar Value for both Won and Lost Records.

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 for all records = 64%

How would I accomplish this?

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,353 questions
0 comments No comments
{count} votes