Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
I have two metrics and the graph looks like that:
Completion Expected =
CALCULATE (
COUNTROWS ( VALUES ( StaticBacklog[ID_Number_Desc] ) ),
FILTER ( ALL ( 'Date_DIM' ), Date_DIM[Date] >= MAX (Date_DIM[Date]) || ISBLANK(Date_DIM[Date]))
)
Completion Actual =
CALCULATE (
COUNTROWS ( VALUES ( StaticBacklog[ID_Number_Desc] ) ),
FILTER (
ALL ( 'Date_DIM' ),
Date_DIM[Date] >= MAX ( Date_DIM[Date]) || ISBLANK ( Date_DIM[Date] )
),
USERELATIONSHIP ( Date_DIM[Date], StaticBacklog[Decision Made Date] )
)
How do i make the brownish line only lead up to today and the other line goes further into the future?
Solved! Go to Solution.
Completion Actual =
Var result =
CALCULATE (
COUNTROWS ( VALUES ( StaticBacklog[ID_Number_Desc] ) ),
FILTER (
ALL ( 'Date_DIM' ),
Date_DIM[Date] >= MAX ( Date_DIM[Date]) || ISBLANK ( Date_DIM[Date] )
),
USERELATIONSHIP ( Date_DIM[Date], StaticBacklog[Decision Made Date] )
)
Return
If( max( Date_DIM[Date] ) < today(), result)
Completion Actual =
Var result =
CALCULATE (
COUNTROWS ( VALUES ( StaticBacklog[ID_Number_Desc] ) ),
FILTER (
ALL ( 'Date_DIM' ),
Date_DIM[Date] >= MAX ( Date_DIM[Date]) || ISBLANK ( Date_DIM[Date] )
),
USERELATIONSHIP ( Date_DIM[Date], StaticBacklog[Decision Made Date] )
)
Return
If( max( Date_DIM[Date] ) < today(), result)
| User | Count |
|---|---|
| 76 | |
| 36 | |
| 31 | |
| 29 | |
| 26 |