Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
@BFroc,
Please share sample data of your tables here and post expected result based on sample data.
Regards,
Lydia
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |