Forum Discussion
Function to show repeated repaired tools
There are a few ways you could do this.
The simplest one is to use the following measure
Count = VAR RowCount = COUNTROWS ( Table1 ) RETURN IF ( RowCount > 1, RowCount, BLANK () )then just have a table with the part column and this measure. Then add a date slicer and any parts that have more than one occurrence will show in the table.
If you want to do it in a measure it can depend on the final context for this use.
can you please post some sample data, if you cannot share it then please make some dummy data that has the same issue
Hi Thomas,
here is some data I got from my report:
Equi Serial number Creation date (inbound) MASTERORDEREQUIPM 08.01.2016 07:57:22 D478061 08.07.2016 14:40:45 G5590320 26.09.2016 12:55:50 D8383433 05.09.2016 20:23:09 D478061 05.09.2016 20:30:21 C661230
C661230
19.09.2016 15:57:29
30.09.2016 15:57:29
When it is there to be repaired, you can see the serial number twice. What I want to see is, when the same tool (same serial number) is more than one time in our workshop in for example one month.
Is there a function to show that?
There are a few ways you could do this.
The simplest one is to use the following measure
Count = VAR RowCount = COUNTROWS ( Table1 ) RETURN IF ( RowCount > 1, RowCount, BLANK () )then just have a table with the part column and this measure. Then add a date slicer and any parts that have more than one occurrence will show in the table.
If you want to do it in a measure it can depend on the final context for this use.