Using What If Parameters in the Table Constructor to build a Dimension Table

[BFroc]

Hey everyone,

I'm building a data model and related reports for scenario analysis, and I'd like to allow the users to pass in multiple what if parameters to the data model. Once that's done, several of them will need to be pulled together into dimension tables in order to do all the maths, rather than repeating the same equations over and over again for each permutation of the model. This is what I'm using to try and build the dimension tables.

VAR BlankTable = {
            ("Small", 'Small Bin Size'[Small Bin Size Value]),
            ("Medium", 'Medium Bin Size'[Medium Bin Size Value]),
            ("Large", 'Large Bin Size'[Large Bin Size Value])
        }
RETURN SELECTCOLUMNS(BlankTable,
    "ContainerSizeName", [Value1],
    "ContainerSizeVolume", [Value2])

Pulling each What If Parameter into the future calculations works fine, but I'd like to batch all these calculations together in vector math to avoid mucking up a calculation step in the future. Now, I could define these tables myself, but that would eliminate the self-service report I'm trying to build to allow my end users the flexibility to perform the scenarios themselves. 

[v-yuezhe-msft]

@BFroc,

Please share sample data of your tables here and post expected result  based on sample data.

Regards,
Lydia

[BFroc · Accepted solution]

Hey @v-yuezhe-msft,

thank you for getting back to me. I now realize that what I was asking the software to do was not allowed. I was creating a new table for the model, but trying to define it via measures in the model, which is not compatible with the way the reporting layer and model layer load. I'm sorry I didn't get back to you sooner.

Thanks,

Barrett