Solved! Go to Solution.
@Samarth-Borade
Please refer to attached sample file with the proposed solution
RevCum_Revenue =
VAR CurrentRevenue =
SUM ( 'Table'[Revenu] )
VAR T1 =
SELECTCOLUMNS (
ALLSELECTED ( 'Table'[Customer Cod] ),
"@Revenue", CALCULATE ( SUM ( 'Table'[Revenu] ) )
)
VAR T2 =
FILTER ( T1, [@Revenue] >= CurrentRevenue )
RETURN
SUMX ( T2, [@Revenue] )
Any leads?
@Samarth-Borade
Please refer to attached sample file with the proposed solution
RevCum_Revenue =
VAR CurrentRevenue =
SUM ( 'Table'[Revenu] )
VAR T1 =
SELECTCOLUMNS (
ALLSELECTED ( 'Table'[Customer Cod] ),
"@Revenue", CALCULATE ( SUM ( 'Table'[Revenu] ) )
)
VAR T2 =
FILTER ( T1, [@Revenue] >= CurrentRevenue )
RETURN
SUMX ( T2, [@Revenue] )
User | Count |
---|---|
105 | |
30 | |
22 | |
18 | |
15 |
User | Count |
---|---|
98 | |
22 | |
19 | |
17 | |
17 |