Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |