Forum Discussion

Anya_T's avatar
Anya_T
Frequent Visitor
5 years ago
Solved

Quality Percentage

Hi,   I I have data in a column in this form   audit_sample_status decision SAMPLE_UNPICKED   SAMPLE_PICKED Correct SAMPLE_UNPICKED   NOT_SAMPLED   SAMPLE_PICKED Correct ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anya_T , Try a measure like

     

    divide(countx(filter(Table, [audit_sample_status] = "SAMPLE_PICKED" && [decision] = "Correct"), [audit_sample_status] ),
    countx(filter(Table, [audit_sample_status] = "SAMPLE_PICKED" && [decision] in{ "Correct" , "Inorrect" }), [audit_sample_status] ) )

amitchandak's avatar
amitchandak
Super User
5 years ago

Anya_T , Try a measure like

 

divide(countx(filter(Table, [audit_sample_status] = "SAMPLE_PICKED" && [decision] = "Correct"), [audit_sample_status] ),
countx(filter(Table, [audit_sample_status] = "SAMPLE_PICKED" && [decision] in{ "Correct" , "Inorrect" }), [audit_sample_status] ) )