Hi,
Have a table that contains around 30 fields and around 30,000 rows of data that comes from a direct query, so cannot create a Collumn.
I have tried to create a measure that would generate a ranking grouped by Sales Date and Location Machine with the Earliest Actual Start time being the factor to Rank by with the Earliest (date/time) being 1 and latest date/time in the group being (example) 12 of 12...
When I run it I get Arguement "4" in Allexcept function is required.
RunSequence =
VAR A =
RANKX (
CALCULATETABLE (
'ipp IPP_Daily_Report',
ALLEXCEPT ( 'ipp IPP_Daily_Report', 'ipp IPP_Daily_Report'[location_machine], 'ipp IPP_Daily_Report'[sales_date],)
),
'ipp IPP_Daily_Report'[Earliest Actual Start Time Production],
,
ASC,
DENSE
)
VAR B =
COUNTROWS (
CALCULATETABLE (
'ipp IPP_Daily_Report',
ALLEXCEPT ( 'ipp IPP_Daily_Report', 'ipp IPP_Daily_Report'[sales_date], 'ipp IPP_Daily_Report'[location_machine])
)
)
RETURN
A & "of " & B
