number of ids on work stations

[Tommyvhod]

Hi all.

I would like to count the number of IDs on each working stations. 1 ID goes trough all working stations and I would like to see the actual status of the product. E.g:

Work st.	ID
1	1101
2	1101
3	1101
4	1101
5	1101
6	1101
7	1101	*
1	1102
2	1102
3	1102	*
1	1103
2	1103
3	1103
4	1103
5	1103
6	1103
7	1103
8	1103	*
1	1104
2	1104	*
1	1105	*

All IDs got trough work station 1. But only 1103 got trough work station 8 ( last work stations marked with star)

I would like count the number of IDs on each work station but only the highest work station. So I would like to see the number of stars ( number of IDs on last work stations)

I was only able to count all IDs on each work stations ( so 5 IDs on 1 ,4 IDs on 2 , 3IDs on 3 and so on)

My goal is to show that work station 1 - 1ID, 2-1ID, 3-1ID,4-0ID,5-0ID,6-0ID,7-1ID,8-1ID

Thank You

[Greg_Deckler]

God help me, I think I understand this... 🙂

Measure 2 = 
    VAR __WorkSt = MAX([Work st.])
    VAR __table = SUMMARIZE(ALL('Table5'),[ID],"__Max",MaX([Work st.]))
    VAR __count = COUNTROWS(FILTER(__table,[__Max] = __WorkSt))
RETURN
    IF( ISBLANK(__count), 0 , __count)

See attached, Page 3, Table5

[Tommyvhod]

Thank you for the quick reply. Yes in the table you created seems to work. I added to my table and it shows wrong number. Probably becouse I have slicers mon " Table5" and with ALL it removes the filters. ( i have a slicer for product name and status, with that I am unable to filter out the finished parts and see only the WIP)

[Greg_Deckler · Accepted solution]

Try ALLEXCEPT to preserve your filters perhaps.

[Tommyvhod]

I added ALLEXCEPT; but here I should add all the columns which are filtered on my dashboard? Becouse I tried that and now I should have 19pcs in WIP and this shows 813 🤔🙂

[Tommyvhod]

I tried ALLSELECTED with this it removes the filter from the formula but keeps the slicers on the Page.

Finally.... it works.... thank You very much