Help calculating utilization rate %

[cdawidow]

 Hi guys, I was wondering if it was possible through DAX to calculate the utilization rate based on product line referenced in the above table like the one shown below?  Currently I can only show the total utilization rate based on sku's found in my sales table (27 in total) but i want to calculate the utilization rate of the total mount (71) if it is possbile?

[harshnathani]

Hi @cdawidow ,

Not very clear but I assume the same measure of Utilization Rate% can be used.

Just add the Utilization Rate% in the table which you have highlighted.

Regards,

Harsh Nathani

[amitchandak]

@cdawidow , No very clear. Can you explain with example

Try like

divide(sum([sku Hits]), sum([count contract]))