Forum Discussion
1000000 limit hit for 6 data points
I understand the need for such a limit but I don't get why I'm hitting the limit when the visual only needs to populate 6 data point. the measure is: £ Receivable P&F (Closing) =
VAR _Da...
SUMX means it is iterating over the entire table. Can you do some sort of pre-filter to reduce the row count?
what exactly do you mean by "pre-filter"? if I filter the visual then the other metrics stop working. For example, filtering to year-end only would mean the revenue figures would be wrong as they would be missing the 364 days revenue prior to year-end.
or am I being dim and there's a way to filter in the dax? I don't understand how Microsoft want me to solve this and its an extremely basic use case, so I'm really quite confused.