The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have created a column but it now giving 100%, I have used this column Dax
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]))
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.
have you got filters on your visual, can you share some sample data please?
Proud to be a Super User!
no filters are applied on visual.