Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculate the cummulative sum in Matrix with sorting applied and then 50% of it on the Measure

Hi All,   I have a matrix wherein i am trying to calculate the running total partition by three dimension in sequence Document No., Product Name and Product ID. Data source:   calculating ...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Jihwan,

 

I tried approach suggested by you.

 

It is giving proper output but it is working only for specified column which I shared with you in excel.

 

 To make it other slicer effective on it , instead of "ALL" in DAX I changed to "ALLSELECTED".

 

It is not working for large size of data.

Giving below error:

 

 

can you please suggest for larger volume of data.

 

Regards,

Robin Yadav 

 

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Thank you for your feedback.

Please share your sample pbix file's link here, then I can try to look into it to come up with accurate solution.

Thanks.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Jihwan,

     

    As I am working on client data, it cannot be shared.

     

    Give me some time, I will mask entire data and will share.

     

    Thanks,

    Robin Yadav