Forum Discussion
Patrick90
3 years agoNew Member
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 ...
- Anonymous2 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
Anonymous
2 years agoNot applicable
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