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.
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.