Quick question: Percentage of sum total in a table not working

[singleton2787]

How would I calc the percentage of the CapEx total to the WorkitemID total? I can do it my head but I'm at a loss to have PBI do it
2 percent of 31 is 6.4%

[singleton2787]

@v-yangliu-msft 

How would I adjust seeing TagName is in a table called Features, and WorkitemID is in the table, Stories

The measure doesn't error out but I'm getting zeros 

[v-yangliu-msft]

Hi  @singleton2787 ,

Here are the steps you can follow：

1. Create measure.

Measure =
var _CapEx=
SUMX(FILTER(ALL('Table'),
CONTAINSSTRING('Table'[TagNames],"CapEx")=TRUE()),[WorkItemld])
var _allcount=
SUMX(ALL('Table'),[WorkItemld])
return
DIVIDE(_CapEx,_allcount)

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