Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have a measure that I need to add some logic to which would write: If a quote has an order date then return blank. How would I add that extra logic in to my below measure? Thanks.
(1.2) =
var _date = SELECTEDVALUE('Date'[Date])
var _avgquote = AVERAGEX(Cycletime,Cycletime[quote_total])
return
IF(HASONEVALUE(Cycletime[QuoteNum]),
_avgquote,
SUMX(filter(Cycletime,Cycletime[EntryDate]>_date),_avgquote))
Solved! Go to Solution.
@Tripb44
Not sure how your model and the visual are setup, can you try the following:
m =
VAR _date =
SELECTEDVALUE ( 'Date'[Date] )
VAR __t = FILTER ( Cycletime , Cycletime[Order Date] = BLANK () )
VAR _avgquote =
AVERAGEX ( __t, Cycletime[quote_total] )
RETURN
IF (
HASONEVALUE ( Cycletime[QuoteNum] ),
_avgquote,
SUMX ( FILTER ( __t, Cycletime[EntryDate] > _date ), _avgquote )
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Tripb44
Can you try this measure ?
Measure =
var _date = SELECTEDVALUE('Date'[Date])
var _avgquote = AVERAGEX(Cycletime,Cycletime[quote_total])
return
IF(
NOT(ISBLANK (Cycletime[order date]) ) &&HASONEVALUE(Cycletime[QuoteNum]),
_avgquote,
SUMX(filter(Cycletime,Cycletime[EntryDate]>_date),_avgquote)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
It is not allowing me to select OrderDate from the table for some reason?
@Tripb44
Not sure how your model and the visual are setup, can you try the following:
m =
VAR _date =
SELECTEDVALUE ( 'Date'[Date] )
VAR __t = FILTER ( Cycletime , Cycletime[Order Date] = BLANK () )
VAR _avgquote =
AVERAGEX ( __t, Cycletime[quote_total] )
RETURN
IF (
HASONEVALUE ( Cycletime[QuoteNum] ),
_avgquote,
SUMX ( FILTER ( __t, Cycletime[EntryDate] > _date ), _avgquote )
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 97 | |
| 74 | |
| 50 | |
| 48 | |
| 46 |