Fuel gauge percent to total by status

[Dave-ExpSC]

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.

[Anonymous · Accepted solution]

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

[Dave-ExpSC]

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