Measure shows wrong total, does not take into account all Months
Hello Community, I created a Measure which forecast values for Months which currently do not have any Data. In a Matrix it shows the correct results for exisiting months(current value of a measure) and for months, where the Measure is currently blank. But the total is wrong. It still only show the total for the existing months. The measures are based on my facttable. The Fact table currently has data until end of August. There are no rows for Months after august. Also when i put the Measure as a Column in my Date Table, it only returns the results for months which are available in the Fact Table.
Incorrect Total
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 = IFERROR( (COUNT(DIM_Calendar[Days in Month])/('Measures Table'[Actual_Sales]/'Measures Table'[Average AR])), BLANK() )+0 Would appreciate if any help is given! 🙂 Thank you.
