DateDiff and Date Slicer

[Dhamu_114]

Hi, I am working in equipment utilization report. I need to calculate total number of dates btw my date column, based on the date slicer. So used Datediff as measure And utilization per day is Total hours / No. of days, where Total hours is Column and No. of Days is measure. Hence cannot use datediff measure in denominator. The utilization comes as infinity. Really helpful if someone gives valuable ideas.

[v-yuta-msft]

Hi Dhamu_114,

Which columns are measure  No. of days based on? Could you please give me some DAX formula and sample data about your measure?

Regards,

Jimmy Tao