Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to 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
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
@jcoolen09
Create a measure with our code.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
our code?
User | Count |
---|---|
14 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
19 | |
4 | |
3 | |
1 | |
1 |