Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Syndicate_Admin
Administrator
Administrator

Cumulative Percentage by Days, Month, Year and other variables

Dear

I need your support, I want to create a graph of increasing lines in percentage, that is, add the amount recovered (AMOUNT PAID) and divide it with the total that is assigned (USD QUOTA) but this cumulatively (daily), the idea is to be able to buy by months or suppliers or different criteria and that the lines move according to the filters used.

For example

The -10th day of the month of Set21 my accumulated recovery is 1%

The -10 day of the month of Oct21mi accumulated recovery is 1.5%

The day -10 of the month of Nov21mi accumulated recovery is 1.5%

.

.

.

On the 20th of the month of Set21 my accumulated recovery is 84%

The 20th day of the month of Oct21mi accumulated recovery is 85%

On the 20th of the month of Nov21mi accumulated recovery is 86%

.

.

etc.

a5602bd2-fd9c-4d28-8d73-92a35f4869da.jpg

The data I have in my table are:

tabla.JPG

In advance thank you for your comments

Some doubt they send me

Best regards

miguel o.

2 REPLIES 2
v-eqin-msft
Community Support
Community Support

Hi @Syndicate_Admin ,

 

Sorry for that the information you have provided is not making the problem clear to me.

 

What's the logic of the accumulated recovery?  Could you please provide me with more details about your table in Text/Table format?( not in a screenshot) Or share me with your pbix file after removing sensitive data.

Refer to:

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

 

 

Best Regards,
Eyelyn Qin

 

Hello

The logic of the recovery is Amount Paid / (between) USD Fee, this will give me as a result the percentage of recovery, but what I want is to do it cumulatively.

I was working on the solution but in some days the percentage falls when I make my accumulated sum

What I did create a MEASURE (Acumulado_Proveedor_Monto_Pago) where I made an accumulated sum per day of the Amount Paid

Acumulado_Proveedor_Monto_Pago = (CALCULATE(SUM(KPI_PREJUDICIAL[Payment Amount]),
FILTER(ALLEXCEPT(
KPI_PREJUDICIAL,
KPI_PREJUDICIAL[Cycle],
KPI_PREJUDICIAL[Mes_Ano],
KPI_PREJUDICIAL[SECTION],
KPI_PREJUDICIAL[SUB_TRAMO],
KPI_PREJUDICIAL[Provider]
),
KPI_PREJUDICIAL[DIA_GESTION]<= MAX(KPI_PREJUDICIAL[DIA_GESTION]))))

What I did create a MEASURE (Acumulado_Proveedor_Monto_Asignado) where I made an accumulated sum per day of the USD Quota

Acumulado_Proveedor_Monto_Asignado = (CALCULATE(SUM(KPI_PREJUDICIAL[USD Fee]),
FILTER(ALLEXCEPT(
KPI_PREJUDICIAL,
KPI_PREJUDICIAL[MES_TEXTO],
KPI_PREJUDICIAL[Mes_Ano],
KPI_PREJUDICIAL[Provider],
KPI_PREJUDICIAL[Cycle],
KPI_PREJUDICIAL[SECTION],
KPI_PREJUDICIAL[SUB_TRAMO]
),
KPI_PREJUDICIAL[USD Fee])))

To then make the division between the 2 measures

Recovery % Supplier = KPI_PREJUDICIAL[Acumulado_Proveedor_Monto_Pago]/KPI_PREJUDICIAL[Acumulado_Proveedor_Monto_Asignado]

Miguel_Ortiz_0-1657925539479.png

I do not know if I am doing well but if you need more data to help me I would appreciate it

Best regards

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.