Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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] )