Calculate Earned Value in DAX (not based on a date)

[Syndicate_Admin]

Hello

I come to you with a question in PBI that I can't resolve.

Scenario:

I have some companies with a turnover value

Task

- Create a cumulative billing column like the one seen in the example, as well as one with the corresponding percentage.

- The cumulative turnover column must be sorted by the turnover value of each company, with the first being the one with the highest amount.

- It has to be a dynamic DAX formula that allows the table to be filtered by other secondary fields in the table that are not shown here (e.g. dates, geography, etc.)

The ranking table is created based on turnover and company, but I can't make a formula that correctly shows the cumulative.

Thank you in advance for any help provided,

Best regards

[Syndicate_Admin]

Good afternoon

Does anyone know how I could solve the filter problem I discussed in my previous post?

Thank you in advance,

Best regards

[Syndicate_Admin]

Thank you so much for your help with the formula. I've applied it, but it only works for me when I apply filters. If I don't apply them, it fails:

Applying filters:

No filters:

Can you think of a reason why this might be happening?

Thanks in advance for the help,

Best regards,

[amitchandak]

@Syndicate_Admin , You should able to use Window function for that

Try like

Cumm Based on Measure = CALCULATE([Your Measure], Window(1,ABS,0,REL, ALLSELECTED('Table'[company]),ORDERBY([Your Measure],Desc)))

Cumm Based on Measure = CALCULATE([Your Measure], Window(1,ABS,0,REL, addcolumns(ALLSELECTED('Table'[company]), "_m1", [Your Measure]),ORDERBY([_m1],Desc)))

Refer the usages here

Power BI Window: Pareto Analysis Again, 80% of sales, Order by Measure when REL position is used: https://youtu.be/GpoITi_tRIw

Continue to explore Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f