Forum Discussion
Generate Series from filtered table
Hi Everyone,
I have a question about generate series.
I have a main table called standard data.
From that table I created a summary table MinMaxStds:
MinMaxStds =
SUMMARIZE (
VStandardData,
VStandardData[Material],
VStandardData[OperationNumber],
"MinStd", MIN ( VStandardData[ProposedStd] ),
"MaxStd", MAX ( VStandardData[ProposedStd] ),
"IDX", CONCATENATE (
CONCATENATE ( VStandardData[Material], "_" ),
VStandardData[OperationNumber]
)
)
I would like to generate a series between the MinStd and MaxStd.
I have tried:
ProposedStds =
GENERATESERIES (
CALCULATE ( MIN ( MinMaxStds[MinStd] ) ),
CALCULATE ( MAX ( MinMaxStds[MaxStd] ) ),
.5
)
However the result set always contains all values even when visuals are filtering the data.
I have a one to many relationship set between IDX on the MinMaxStds table and the main data table VStandardData table.
I have tried all manner of filters in the statement but can't seem to get it right.
Any help would be greatly appreciated.
Kerry