Filter out the data when the conditions are not fully match

[sumpekung]

Hi,

I'm trying to sort some rows out if those rows not match all conditions.

I need to compare the defect by date between 2 operations but I want to compare only the lot that already pass both operations. Is there any way to sort the rows out via power query or measure function?

Thanks,

[wdx223_Daniel]

OperationCount=CALCULATE(DISTINCTCOUNT(Table[Operation]),ALLEXCEPT(Table,Table[Date],Table[Lot]))

[FreemanZ]

hi @sumpekung 

not sure if i fully get you, you may try to add a measure like this:

measure = COUNTROWS(VALUES(TableName[Operation]))

you may plot a table visual with Lot column and the measure, like this:

or you can feed filter pane for a visual with the measure and show the items when the value is 2, like this:

[sumpekung]

My whole data table contains many rows for each lot and not same row quantity in each lot, so it doesn't work with ny data.
Thank you in advance krub @FreemanZ .

[FreemanZ]

hi @sumpekung 

then could you update your sample date to fully refect the issue?

[sumpekung]

Thank you in advance for follow up with a great support krub. Anyway, I already fixed my problem with the idea from you and @olgad .

[olgad]

Hi, 
New Count=

If(If(CALCULATE(Count(Table[lot]), Table[Operations] = 1) = CALCULATE(Count(Table[lot]), Table[Operations] = 2),1,0)=1, Sum(Table[Defect]))

Please kudo and like the solution if it works for you. 

[sumpekung · Accepted solution]

Hi @olgad ,

Thanks again krub. I already fix the issue. I create MAX Operation column by power query and sort the operation#1 out and use measure as below.

Test Count = If(If(CALCULATE(Count('Table'[Lot]), 'Table'[Operation] = 2) > 0 ,1,0)=1, Sum('Table'[Defect]))

[sumpekung]

Thanks @olgad , sorry for the less information I provide. My data set contains multiple days, then it still sum defect from all lots I have. Now I'm trying to adapt your idea if it can work.