Forum Discussion
Blank First Row When Calculating Running Percentage
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
Hi v-kkf-msft
The formula you provided does work if the visual is sorted in ascending order by vendor - this obviously causes the formula provided by Jihwan Kim to error out:
I have also confirmed that in the formula he provided I do have >= in the formula:
I should mention that 99% of the time we are going to be sorting Total Spend in descending order, which again, works some of the time with Jihwan Kim's formula. We are usually using this visual to identify top vendors by spend and determine the top 80% of vendors by spend - so it's important that the calculation work for summation by total spend. If this would make a difference in the formula you provided, please update that to reflect our needs as stated above and we can try that.
Again, I am at a loss as to why some filters work but others don't. Doesn't that seem odd? There is no cause I can detect. I have recreated the slicers/pie charts and still receive the same results. The underlying data is also free from errors. I have also tried simply creating another measure with the same formula just to eliminate that small possibility but to no effect.
I sincerely appreciate your continued assistance with this.
Michael