Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 P
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.
% 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]) ) )
I did not use this measure, it blocks the Power Bi and does not yield results
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
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
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |