cancel
Showing results for
Did you mean:
Helper II

## Fuel gauge percent to total by status

I am relatively new to Power BI so assistance is greatly appreciated.
I am analyzing project management data. There are no data fields. It’s all text.
Analysis primarily consists of tracking progress of project activities “status”.

I have the following relevant fields.
[Region], [Brand], [Activity], [Status] – they all sit in the ('Brand data') table
I have multiple Regions – with multiple Brands – many Activities – tracked by Status (Not Started, In Progress, Complete)
I want to create a Fuel Gauge visual that dynamically displays the “% Status” when I use the slicers of Region or Brand or Status.

I believe I need to create the following measures:
STATUS COUNT = “dynamically count the rows of status by slicer selection”
TOTAL BRAND ROWS = “count the total number of rows for the Brand based on slicer selection”
PERCENT STATUS = “STATUS COUNT / TOTAL BRAND ROWS”

I think that should provide enough information to solve the DAX formula. I’ve tried a lot of different ideas but find myself going in circles. Thanks for the help in advance.

1 ACCEPTED SOLUTION
Responsive Resident

Hi Dave,

The question is not 100% clear (at least not for me).

so this is my current intepretation:

STATUS LINES := Var _Status = VALUES('Table'[Status])
return CALCULATE(COUNTROWS('Table'), _Status)

BRAND LINES := CALCULATE( COUNTROWS('Table'), ALLEXCEPT('Table','Table'[Brand]))

PERCENTAGE = DIVIDE([STATUS LINES] , [BRAND LINES])

If this is  not a solution... A small set of sample data and expected outcome makes it easier to help you in solving you issue.

Jan

2 REPLIES 2
Responsive Resident

Hi Dave,

The question is not 100% clear (at least not for me).

so this is my current intepretation:

STATUS LINES := Var _Status = VALUES('Table'[Status])
return CALCULATE(COUNTROWS('Table'), _Status)

BRAND LINES := CALCULATE( COUNTROWS('Table'), ALLEXCEPT('Table','Table'[Brand]))

PERCENTAGE = DIVIDE([STATUS LINES] , [BRAND LINES])

If this is  not a solution... A small set of sample data and expected outcome makes it easier to help you in solving you issue.

Jan

Helper II

Thank you. I don't understand the Status Lines formula but it works. Much appreciated.

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors