Need Help with a Measure Formula

[Zaky]

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

[Anonymous · Accepted 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.

[Zaky]

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.

#OFF Measure =

CALCULATE(DISTINCTCOUNT('ICT Key Statistics July 2019'[AUPEC Definition]), 'ICT Key Statistics July 2019'[Physical or Travel] IN { "offshore"})

Apart of that, is there any chance to make the "(Blank)" series to be default as "0"?

[Anonymous]

Hi @Zaky ,

Sorry for late reply, please try:

#OFF Measure =
IFERROR(

CALCULATE(DISTINCTCOUNT('ICT Key Statistics July 2019'[AUPEC Definition]), 'ICT Key Statistics July 2019'[Physical or Travel] IN { "offshore"})  
, 0 )

Cheers,
Rob