Running Total for a measure without Date Column

[DSPVarma]

Please help me out with a running total measure. I tried many ways but those are not working for my Matrix visual.

The first 6 columns (i.e., PCC to Booking Count) are from the DSRReport Table.
% Net Contribution and Projected Fund are measures.

The data should be ranked dynamically based on % Net Contribution (Highest to lowest). I want the Running total for the Projected Fund.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[DSPVarma]

@Ashish_Mathur @lbendlin I've included for you the link to the file. I should work on the Data Modelling, but for now, this solution helps me a lot.

https://drive.google.com/file/d/121ohS5gG45sxxg2ogyp61qXcdaoRJbxi/view?usp=drive_link

[lbendlin]

link asks for access, please verify.

[DSPVarma]

Please try it now

https://drive.google.com/file/d/121ohS5gG45sxxg2ogyp61qXcdaoRJbxi/view?usp=sharing

[Ashish_Mathur]

That file is very big.  Dragging a measure to the visual is taking way tool long to process. Share an abridged version of the file.  Remove the unrequired tables//easures and share the revised download link.

[DSPVarma]

Please try this one. I removed as many tables and measures as possible.
https://drive.google.com/file/d/1-ublw8l8sF1_dbxTV6gyCk_pPe8UIvRp/view?usp=sharing

[Ashish_Mathur]

That still takes too long.  May be someone else can help you.

[lbendlin]

Use RANKX, or SUMX of all values that are greater or equal than the current value.