The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I need help.
I am trying to create a measure that counts the # of items ordered since an account was created. I manually keyed 01/01/2022 in the measure below and was able to get the result I expected.
COUNTROWS(
GROUPBY(FILTER(Table,Table[First Sample Date]>= DATE(2022,01,01)),Table[Sample ID],Table[Order Choice Type])
)
Unfortunately, I can't figure out how to update the syntax in the measure to dynamically display correctly based on the minimum date in the visual or a slicer.
COUNTROWS(
GROUPBY(FILTER(Table,Table[First Sample Date]>= CALCULATE(min('Calendar'[DATE]),ALLSELECTED('Calendar'[DATE])),Table[Sample ID],Table[Order Choice Type])
)
Below are screenshots of the baseline (with the expected values) as well as the incorrect values based on my failed attempt.
Any help is appreciated!
Solved! Go to Solution.
@Anonymous , Try like
New=
var _min = minx(allselected('Calendar') ,'Calendar'[DATE])
return
calculate(COUNTROWS(Summarize(Table, Table[Sample ID],Table[Order Choice Type])),FILTER(Table,Table[First Sample Date]>= _min)
)
or
New=
var _min = minx(allselected('Calendar') ,'Calendar'[DATE])
return
calculate(COUNTROWS(Summarize(Table, Table[Sample ID],Table[Order Choice Type])),FILTER(all(Table),Table[First Sample Date]>= _min)
)
@Anonymous , Try like
New=
var _min = minx(allselected('Calendar') ,'Calendar'[DATE])
return
calculate(COUNTROWS(Summarize(Table, Table[Sample ID],Table[Order Choice Type])),FILTER(Table,Table[First Sample Date]>= _min)
)
or
New=
var _min = minx(allselected('Calendar') ,'Calendar'[DATE])
return
calculate(COUNTROWS(Summarize(Table, Table[Sample ID],Table[Order Choice Type])),FILTER(all(Table),Table[First Sample Date]>= _min)
)
User | Count |
---|---|
25 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
31 | |
11 | |
10 | |
10 | |
9 |