Forum Discussion
Running Total for a measure without Date Column
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.
8 Replies
Use RANKX, or SUMX of all values that are greater or equal than the current value.
Hi,
Share the download link of the PBI file.
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
link asks for access, please verify.
