Forum Discussion
Sorting by Column Corrupting Matrix
Hi guys, I've got a customer sort order of a variable Reorder Bucket, the columns on a few of my matrices. When I apply the sort to the column, the matrices become corrupted - only the first colu...
- Hi Anonymous ,You can refer to this blog, which explains the problem:Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
You can refer to this blog, which explains the problem:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi V-lianl-msft,
I've managed to use this solution for most of my graphs but on one, I cannot get it to work. Whatever I try, it just ends up with a failed graph and the error "Can't display the visual. There's not enough memory to complete this operation."
Do you have any idea what I can try? Below is the measure that's failing when the other measure "Retention Buckets" is amended to filter on both master and sort columns.
Cumulative Retention Quarterly = CALCULATE([Retention Buckets]*AVERAGE(Orders[Total Amount]),FILTER(ALLEXCEPT(Orders,Orders[Region],Orders[Trial (month/year)],Orders[Trial quarter]),Orders[Reorder Bucket Priority]<=MAX(Orders[Reorder Bucket Priority])),Orders[Reorder Bucket Priority]>0)
Here are the new and old definitions of Retention Buckets:
Retention Buckets (NEW) =
Divide(COUNTA(Orders[Clarity Order ID]),
CALCULATE(counta(Orders[Clarity Order ID]),Orders[Reorder Bucket]="T",Orders[Reorder Bucket Priority]=1)
Retention Buckets (OLD) =
Divide(COUNTA(Orders[Clarity Order ID]),
CALCULATE(counta(Orders[Clarity Order ID]),Orders[Reorder Bucket]="T")
Thanks
Oli