Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
Wondering if someone would able to help me with formula to count/filter based on ‘AUPEC definition’ column as per data table below.
So it will become:
Physically on-site = 4
Require engineer to travel = 4
Thanks.
REGION | Area | Main Site | AUPEC Definition | Physical or Travel |
EAST COAST | KT | KT | INSTEP | physically on-site |
EAST COAST | KT | KT | INSTEP | physically on-site |
EAST COAST | KT | KT | KLCCUH | physically on-site |
EAST COAST | Paka | KIPC | KIPC | physically on-site |
EAST COAST | Paka | KIPC | KIPC | physically on-site |
EAST COAST | Paka | KIPC | KIPC | physically on-site |
EAST COAST | Paka | KIPC | KIPC | physically on-site |
EAST COAST | Paka | KIPC | KIPC | physically on-site |
EAST COAST | Paka | KIPC | KIPC | physically on-site |
EAST COAST | Paka | KIPC | KIPC | physically on-site |
EAST COAST | Paka | KIPC | PCLDPE | physically on-site |
EAST COAST | Paka | KIPC | PCLDPE | physically on-site |
EAST COAST | Paka | KIPC | PCLDPE | physically on-site |
WEST COAST | Sabah | Kimanis | Kimanis | require engineer to travel |
WEST COAST | Sabah | Kimanis | Kimanis | require engineer to travel |
WEST COAST | Sabah | Kimanis | Kimanis | require engineer to travel |
WEST COAST | Sabah | Kimanis | Kimanis | require engineer to travel |
CENTRAL | Kuala Lumpur | Etiqa | Etiqa | require engineer to travel |
CENTRAL | Kuala Lumpur | Etiqa | Etiqa | require engineer to travel |
CENTRAL | Kuala Lumpur | Etiqa | Etiqa | require engineer to travel |
CENTRAL | Kuala Lumpur | Etiqa | Etiqa | require engineer to travel |
CENTRAL | Kuala Lumpur | Etiqa | Etiqa | require engineer to travel |
CENTRAL | Kuala Lumpur | Binjai | Binjai | require engineer to travel |
CENTRAL | Kuala Lumpur | Intermark | Intermark | require engineer to travel |
CENTRAL | Kuala Lumpur | Intermark | Intermark | require engineer to travel |
CENTRAL | Kuala Lumpur | Intermark | Intermark | require engineer to travel |
CENTRAL | Kuala Lumpur | Intermark | Intermark | require engineer to travel |
CENTRAL | Kuala Lumpur | Intermark | Intermark | require engineer to travel |
Solved! Go to Solution.
Hi @Zaky ,
MEASURE1 = DISTINCTCOUNT( 'Table'[AUPEC Definition] )
Hope that helps.
Cheers,
Rob
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Zaky ,
MEASURE1 = DISTINCTCOUNT( 'Table'[AUPEC Definition] )
Hope that helps.
Cheers,
Rob
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Thanks for your help. The formula working well. Since I wanted it to be seen in KPI visual, i just modify a bit the measure as follow based on "Physical or Travel" field column.
Hi @Zaky ,
Sorry for late reply, please try: