I am having a strange scenario ,which is the case is very straight forward,but i cannot figure out why the results are not populating as expected.
I am going Rank below visual 1st column based on (total AR amount).So i got the rank correctly(i used new rank DAX function,tried out rankx and topn also).
Issue is when drag and drop other dimension fields to this table/matrix visual (RANK_TT measure(2 nd column) it does not populating,It is spinning long time and i am getting an error as "memory not not available for this operation)
RANK_TT measure is this
Total AR amount measure is just a simple sum explicit aggregation .
This is my data model and marked table is the above related one.
I just dragged customer code from top20customer dim(same dimension where parent id reporting column lies) .Visual is spinnnig and generation “out of memory”
Is there any issue with the rank dax i have written or what would be the issue here.
What i am trying to achieve finally is overall ranking on parent customer based on total amount ,whatever the context in visual changes.
Thanks in advance