topic Re: Fuel gauge percent to total by status in DAX Commands and Tips

Fuel gauge percent to total by status

Dave-ExpSC — Fri, 17 Jan 2020 16:35:08 GMT

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.

Re: Fuel gauge percent to total by status

Anonymous — Fri, 17 Jan 2020 19:30:37 GMT

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

Re: Fuel gauge percent to total by status

Dave-ExpSC — Sat, 18 Jan 2020 17:36:42 GMT

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