Not getting 100 % in data view as shown below

[Anonymous]

I have created a column but it now giving 100%, I have used this column Dax

Utilization = DIVIDE(CALCULATE(SUM(SAC[Total Hours])-SUM(SAC[Hours])),SUM(SAC[Total Hours]))

this is a table visual where I am getting this values


this is a created column that was created by using
 Utilization = DIVIDE(CALCULATE(SUM(SAC[Total Hours])-SUM(SAC[Hours])),SUM(SAC[Total Hours]))

[v-lionel-msft]

Hi @Anonymous ,

Please provide a sample .pbix file or sample data.

Best regards,
Lionel Chen

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

[vanessafvg]

have you got filters on your visual, can you share some sample data please?

[Anonymous]

no filters are applied on visual.