Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Not getting 100 % in data view as shown below

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]))

 

Need Help

3 Replies

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    5 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      no filters are applied on visual.

       

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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.