Hi, I am dealing with the common problem of not having my totals add up correctly and I am unsure how to amend it.
Please see the measure below where I am trying to find the number of outstanding days.
Outstanding Days =
(COUNT(DIM_Calendar[Days in Month])/('Measures Table'[Actual_Sales]/'Measures Table'[Average AR])),
Would appreciate if any help is given! 🙂