Forum Discussion

Patrick90's avatar
Patrick90
New Member
3 years ago
Solved

Table Layout Design, Production Schedule

Hello, I have an issue with creating an appropriate table in Power BI, which is meant to serve as a production schedule for the upcoming days on a specific machine, outlining the next production run ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Patrick90 ,

    I created a sample pbix file(see the attachment), please check if that is what you want.

    1. Create two dimension tables as below screenshot

    Dimension table: MachineProduction

    Dimension table: Sie

    2. Create a measure as below to get the next production

    NextProductionP = 
    VAR _selmachine =
        SELECTEDVALUE ( 'MachineProduction'[Machine] )
    VAR _selprod =
        SELECTEDVALUE ( 'MachineProduction'[Production] )
    VAR _selsei =
        SELECTEDVALUE ( Sie[Sie] )
    VAR _selshift =
        SELECTEDVALUE ( 'Plan'[Shift] )
    RETURN
        CALCULATE (
            MAX ( 'Plan'[Next production] ),
            FILTER (
                'Plan',
                'Plan'[Machine] = _selmachine
                    && SEARCH ( _selsei, 'Plan'[Start], 1, 0 ) > 0
            )
        )

    3. Create a matrix visual as below screenshot

    Best Regards