Forum Discussion

Kerrymr's avatar
Kerrymr
Icon for Helper I rankHelper I
6 years ago

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

1 Reply

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion

    Hi Kerrymr 

    You seem to be creating a calculated table. Those are static and not affected by filter context at all

     

    Please mark the question solved when done and consider giving kudos if posts are helpful.

    Cheers  Datanaut