Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |