Join 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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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
User | Count |
---|---|
98 | |
76 | |
74 | |
49 | |
26 |