RANK /RANKX DAX not working for different context

DAX DAX Calculations
1

Hi All,
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.

Scenario

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
image

Table visual

image
image486×537 22.4 KB

Total AR amount measure is just a simple sum explicit aggregation .
unnamed

This is my data model and marked table is the above related one.

image
image950×791 34.5 KB

Error screen.

I just dragged customer code from top20customer dim(same dimension where parent id reporting column lies) .Visual is spinnnig and generation “out of memory”

image
image1692×570 48 KB

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

2

HI @ileuschke

Calling-out a specific forum member (or members) is discouraged. It may delay or prevent a response as many forum members will disregard such posts.

Please provide a sample power bi file. It could be your model itself that causing the issue.

thanks
Keith

3

Hi,
Thanks.I removed the tag.

4

please add to origional posting

5

Done.attached to original post.

6

Hi All,i think i figured out the issue,
This might be an issue with native table visual issue,when i select matrix visual figures appear correctly.
Thanks all