count test frequency

[abgnfirdaus]

Hello there. I need help for my problem here. Let say the table is below:

Date tested	Equipment no.	Red cable	Yellow cable	Blue cable
24/2/2019	TRU1	0.1	0.1	0.1
25/2/2019	TRU2	0.12	0.11	0.1
25/2/2019	TRU3	0.1	0.11	0.12
2/3/2020	TRU1	0.2	0.21	0.22
4/3/2020	TRU3	0.21	0.2	0.21
5/6/2021	TRU1	0.3	0.3	0.3

Then, I want to create table/column that will count the number of test for each equipment. The new table should be like this:

Equipment	No. of test done
TRU1	3
TRU2	1
TRU3	2

I hope you guys can help me. Thank you in advance.

[Samarth_18 · Accepted solution]

HI @abgnfirdaus ,

Create a column with below code just in case if any of the column is blank 

Column = COALESCE('Table'[Red cable ],'Table'[Yellow cable],'Table'[Blue cable])

then use this new column as count on your visual

output:-

Thanks,

Samarth

[abgnfirdaus]

How to create a custom column to count how frequent the equipment have been tested.

Table 1:

Date Tested	Equipment	Red cable	Yellow cable	Blue cable
1/2/2018	TRU 1	0.1	0.12	0.1
2/2/2018	TRU 2	0.12	0.14	0.12
2/2/2018	TRU 3	0.12	0.11	0.1
3/4/2020	TRU 2	0.2	0.24	0.21
5/4/2020	TRU3	0.21	0.22	0.21
4/6/2021	TRU3	0.31	0.36	0.31

I want to create new column that will count the frequency of equipment have been tested. The table should show like this:

Equipment	Count of test
TRU 1	1
TRU 2	2
TRU 3	3

Hope you guys can help me. thank you in adavance.

[Samarth_18]

Hi @abgnfirdaus ,

You can refer to below thread:-

https://community.powerbi.com/t5/Desktop/count-test-frequency/m-p/2290371#M830064

Thanks,

Samarth