Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a table like this
Production date | Serial Number | Final Material |
01/01/2019 | 1234 | 601110 |
01/01/2019 | 1235 | 601110 |
01/01/2019 | 1236 | 601110 |
01/01/2019 | 1237 | 601150 |
01/01/2019 | 1238 | 601150 |
02/01/2019 | 1239 | 601150 |
02/01/2019 | 1240 | 601150 |
And Ineed to count the number of times the value "Final Material" changes during one day (so for example during 01/01/2019 it changed two times, during 02/01/2019 zero).
How can I do?
Thanks
Solved! Go to Solution.
Hi @FZU .
You can create a table visual with date and following measure formula to achieve your requirement:
Measure = CALCULATE ( COUNTROWS ( VALUES ( Table[Final Material] ) ), VALUES ( Table[Production date] ) )
Notice: above measure will auto summary current row contents level record and get distinct count of correspond materials.
Regards,
Xiaoxin Sheng
Hi @FZU .
You can create a table visual with date and following measure formula to achieve your requirement:
Measure = CALCULATE ( COUNTROWS ( VALUES ( Table[Final Material] ) ), VALUES ( Table[Production date] ) )
Notice: above measure will auto summary current row contents level record and get distinct count of correspond materials.
Regards,
Xiaoxin Sheng
hello @FZU
Changes = DISTINCTCOUNT ( Table[Final Material] ) -1
If you put this measure against a matrix with the [Production Date] on the rows it should give you what you are looking for.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |