How to have a measure accumulated based on another measure

[Mig]

Hello good morning, I need help to be able to obtain a cumulative measure based on another "measure", which in this case is "%partial", where I need you to accumulate the data from highest to lowest . (example: 38%, 38%+22%, 38%+22%+21%, ....)

It should be noted that I have been able to solve this with other solutions that are proposed in the forum, creating columns, but that fail to filter by date, or when choosing specific data.

Thank you!
Edit: Attached file download link example, I need to accumulate partials 🙂
https://drive.google.com/file/d/1T8ldtFe7XciT_EF4z3vDtgYqLmOBEL7c/view?usp=sharing

[TomMartens · Accepted solution]

Hey @Mig ,

As for your question, I must admit that I have my problems understanding your requirement.

Looking at the screenshot (it's small), I can't figure out your requirement.

Accumulation of relationships from lowest to highest may not return what you expect. This will be the case if there are two or more identical proportions, there may be an implicit order such as date or orderid.

It's always a good idea to prepare sample data by writing the data to Power BI Desktop(https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-enter-data-directly-into-desktop)or using an Excel file for data generation.

Upload the pbix and xlsx to OneDrive or Dropbox and share the link.

Best regards
Tom

[v-zhenbw-msft · Accepted solution]

Hello @Mig ,

We can create two measures to meet your needs.

Total = COUNT(Seg[CATEGORIA])

Cumulative Total based on Rank = 
DIVIDE (
    CALCULATE ( [Total], TOPN ( [rankdinamic], ALL ( Seg[CATEGORIA] ), [Total] ) ),
    CALCULATE ( [Total], ALLSELECTED ( Seg ) )
)

If you don't meet your requirements, could you show the exact expected result based on the table you shared?

Best regards

Community support team _ zhenbw

If this post helps,then consider Accepting it as the solution to help other members find it faster.

BTW, pbix as an attachment.

[TomMartens · Accepted solution]

Hey @Mig ,

As for your question, I must admit that I have my problems understanding your requirement.

Looking at the screenshot (it's small), I can't figure out your requirement.

Accumulation of relationships from lowest to highest may not return what you expect. This will be the case if there are two or more identical proportions, there may be an implicit order such as date or orderid.

It's always a good idea to prepare sample data by writing the data to Power BI Desktop(https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-enter-data-directly-into-desktop)or using an Excel file for data generation.

Upload the pbix and xlsx to OneDrive or Dropbox and share the link.

Best regards
Tom

[Mig]

https://drive.google.com/file/d/1T8ldtFe7XciT_EF4z3vDtgYqLmOBEL7c/view?usp=sharing

[v-zhenbw-msft]

Hi @Mig ,

How about the result after you follow the suggestions mentioned in my original post?

Could you please provide more details or expected result about it If it doesn't meet your requirement?

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.