Calculate Billable Percentage Vs Non Billable Percentage

[glynwilks]

Hello everyone!

I am trying to work out the billable percentage of my service Desk agents, which pulls from an SQL database from HaloPSA. The column in the table I am interested in is called actioncode.

If the value in the column is = -1 then the action is considered non-billable

If the value in the column is anything else, then it is considered billable.

The column looks like 

What I am needing to work out is what percentage of the time entries are billable and what percentage is non-billable

My thoughts were to create a column that was an IF statement saying if actioncode=-1 then non-billable else billable (obviously not the query). But I can't seem to get that to work, and then I don't know how to best create a gauge to make it show billable percentages, based on the month etc.

[bhelou]

Hello , you need to make 2 measures as follow : 

1 : Billable Status = IF(Table1[actioncode] = -1, "Non-Billable", "Billable")

2: Billable Percentage =
DIVIDE(
CALCULATE(COUNTROWS(Table1), Table1[Billable Status] = "Billable"),
COUNTROWS(Table1)
)

Kinely let me know if it works or no , and accept as a solution if it works for you 

[glynwilks]

Thanks for this, I managed to get the first one working, but I seem to be doing something wrong, as I cannot get the second part to calculate. My table is called 'Time Entries (Actions)'