Every row showing same value for custom column

[jcoolen09]

I want to show a percentage for each row. The formula is their Billable Hours column DIVIDED by their Total Hours column. Why is it just showing the same value for every row? 

[Anonymous · Accepted solution]

Hi  @jcoolen09 ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Measure =
var _sumbillable=
SUMX('MARSData',[Billable Hours])
var _sumtotal=
SUMX('MARSData',[Total Hours])
return
DIVIDE(
    _sumbillable,_sumtotal)

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Fowmy]

@jcoolen09 

Create a measure with our code. 

[jcoolen09]

our code?