mapping function for floor plan management

[Anonymous]

Does BI have a mapping function to play with the row length for people in a stadium seating? Is there something like CAD that can be implemented in BI in an efficient way? I need something that allows us to insert different row values to see various layouts that would allow us to accommodate the total number of people.

[v-gizhi-msft · Accepted solution]

Hi,

According to your description, i create an example to show:

1)Create five What-If parameters for end user to choose the info about seat and stadium.

Then create this measure to calculate the total number of people(seats):

Total Number of People =
ROUND (
    SELECTEDVALUE ( Length[Length] )
        / (
            SELECTEDVALUE ( 'Seat Length'[Seat Length] )
                + SELECTEDVALUE ( 'Seat Gap'[Seat Gap] )
        ),
    0
)
    * ROUND (
        SELECTEDVALUE ( Width[Width] )
            / (
                SELECTEDVALUE ( 'Seat Width'[Seat Width] )
                    + SELECTEDVALUE ( 'Seat Gap'[Seat Gap] )
            ),
        0
    )

When select slicers, the result shows:

Hope this cam help.

Best Regards,

Giotto ZHi