Forum Discussion

JulianTobon's avatar
JulianTobon
Icon for Helper I rankHelper I
9 years ago

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 relationsh...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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.

JulianTobon's avatar
JulianTobon
Icon for Helper I rankHelper I
9 years ago

Phil_Seamark

 

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

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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])
					)
				)
    • JulianTobon's avatar
      JulianTobon
      Icon for Helper I rankHelper I
      9 years ago

      Phil_Seamark

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

      • Phil_Seamark's avatar
        Phil_Seamark
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago
        Does it give you an error?