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
JulianTobon
Helper I
Helper I

cumulative percentage

Hello everyone, I require your support to calculate the cumulative percentage. My problem is that "Leads in CRM" is a field of a table other than "Act Customer" and are connected through a relationship, and I have not been able to perform a calculation to have the cumulative percentage according to the number of PCaptura.PNG

 

 

8 REPLIES 8
Phil_Seamark
Employee
Employee

Hi @JulianTobon

 

Are you trying to fix the column that you have highligted in red, or would you like to build a new column that is the cumulative sum of the highlighted column?

 

 Oh and can you please share your formula for the highlighed column.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

@Phil_Seamark

 

% Cust vs. total = RevenueDetails[Act Customer]/CALCULATE(RevenueDetails[Act Customer],ALLSELECTED(RevenueDetails))

HI @JulianTobon

 

How close does this measure get?

 

New Measure = CALCULATE(
				SUMX('RevenueDetails',[% Cust vs. total]),
				FILTER(
					ALL('RevenueDetails'),
					'RevenueDetails'[Num. of PC]<=MAX('RevenueDetails'[Num. of PC])
					)
				)

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

@Phil_Seamark

I did not use this measure, it blocks the Power Bi and does not yield results

Does it give you an error?

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Hi @Phil_Seamark

Yes, Power bi loses its memory capacity and completely blocks the computer (my pc is powerful) also modify the formula then trying to adapt but the accumulated is not expected.

Hi @JulianTobon,

The measure @Phil_Seamark posted is right. While you the accumulated is not expected, could you please share more details or screenshot for further analysis?

Best Regards,
Angelia

Hi @Phil_Seamark

 

I like to build a new column that is the cumulative sum of the highlighted column

 

If you can help me out with this I will appriciate it 

 

 

 

 

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.