Forum Discussion
Solved
Measure returning same value for all rows in matrix
Hi experts, I need help with figuring out why the measure repeats the same value (Which is correct in its total) I want to calculate the sum of backlog of current month (and compare to previous mon...
Your other column names are not shown in your pic, but try the expression below for your variable. I assume you are using the Date_EndMonth column in your slicer, so you need to remove that filter (but not more than that). If so, that is why ALLSELECTED didn't work; it would not remove the filter coming from that slicer. Try just removing only the filter from that column (and if you have a sort column for it, remove that one too).
VAR Backlog_PreviousMonth = CALCULATE( SUM ( 'POC Data'[IFRS Backlog] ), ALL('POC Data'[MonthEndDate], 'POC Data'[MonthSortColumn]), 'POC Data'[MonthEndDate] = Date_PreviousMonth)Regards,
Pat
Your ALLEXCEPT is removing filters from all the columns in that table except for the currency column. Try using ALL or ALLSELECTED to remove filters from just the columns you need.
Regards,
Pat