Forum Discussion

abgnfirdaus's avatar
abgnfirdaus
Helper I
4 years ago
Solved

count test frequency

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....
Need Help
Show and Tell
Tutorial Requests
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    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

     

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

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's avatar
    abgnfirdaus
    Helper I
    4 years ago

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

    Table 1:

    Date TestedEquipmentRed cableYellow cableBlue cable
    1/2/2018TRU 10.10.120.1
    2/2/2018TRU 20.120.140.12
    2/2/2018TRU 30.120.110.1
    3/4/2020TRU 20.20.240.21
    5/4/2020TRU30.210.220.21
    4/6/2021TRU30.310.360.31


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

    EquipmentCount of test
    TRU 11
    TRU 22
    TRU 33


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