Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
105 | |
69 | |
67 | |
43 |
User | Count |
---|---|
151 | |
103 | |
102 | |
87 | |
63 |