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] )
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
19 | |
13 | |
10 | |
9 | |
9 |