Lumira Discovery Numeric Point Chart KPI creating custom measure?

[bassam]

Dear Experts,

In Lumira Discovery 2.3, I am trying to create some numeric point KPI charts in my dashboard from the following dataset (Source is excel) :

KPIs

I am able to create the first three (highlighted in green) but am unable to figure out how can I achieve the last two (highlighted in red)

Total Distinct No Of IDs with Order Taken Applied Once = 4 ( i.e IDs: 1002, 1003, 1006, 1008)

Total Distinct No Of IDs with Order Taken Applied Multiple Times = 3 ( i.e ID: 1001, 1004, 1005)

I would highly appreciate some support in knowing what can I do to achieve the last two KPIs?

Regards,

Bassam