Blank First Row When Calculating Running Percentage

Hello Everyone, I've successfully formulated a running percentage measure that uses the following two measures: PERCENT SPEND MEASURE 1 = var allspend = CALCULATE( [SPEND MEASURE], ALLSELE...

Need Help

v-kkf-msft

Community Support

4 years ago

Hi MStP ,

The formula I provided is cumulative by Vendors column, so please sort the Vendors columns in the Vendors table in ascending order and see if the measure is calculated correctly.

Also, I think the Jihwan_Kim' formula you are using is correct and returns the correct result in my sample data. But based on your screenshot, I noticed that when you select Plant 1, it calculates the accumulation without the current row, i.e. 13%=4%+9%, 17%=4%+9%+4%.

There is no summation of the current row in Running%, which should cause the first row to have a null value. So please make sure you have ">=" instead of ">" in your formula.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz