Forum Discussion
Gantt Matrix Filter out zero rows
I have a problem visualising production plan. Here is the data example: Product Production Start Production End 1111 15/09/2023 27/09/2023 1112 18/09/2023 28/09/2023 1113 20/09/2...
I managed to resolve the issue by myself with separate measure that I used to filter out the products that currently in production:
_Current =VAR PeriodStart = CALCULATE(MIN(Calendario[Dias de Trabalho] ),ALLSELECTED( Calendario[Dias de Trabalho] ))VAR PeriodEnd = CALCULATE(MAX(Calendario[Dias de Trabalho] ),ALLSELECTED( Calendario[Dias de Trabalho] ))VAR Start = MIN(PDP[Entrada na Linha])VAR End = MIN(PDP[Saida da Linha])RETURN IF(AND(Start>=PeriodStart, Start<=PeriodEnd) ||AND(End>=PeriodStart, End<=PeriodEnd) ||AND(Start<=PeriodStart, End>=PeriodEnd),1,0)
I managed to resolve the issue by myself with separate measure that I used to filter out the products that currently in production:
_Current =
VAR PeriodStart = CALCULATE(
MIN(Calendario[Dias de Trabalho] ),
ALLSELECTED( Calendario[Dias de Trabalho] )
)
VAR PeriodEnd = CALCULATE(
MAX(Calendario[Dias de Trabalho] ),
ALLSELECTED( Calendario[Dias de Trabalho] )
)
VAR Start = MIN(PDP[Entrada na Linha])
VAR End = MIN(PDP[Saida da Linha])
RETURN IF(
AND(Start>=PeriodStart, Start<=PeriodEnd) ||
AND(End>=PeriodStart, End<=PeriodEnd) ||
AND(Start<=PeriodStart, End>=PeriodEnd),
1,0)