cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

Need Help with a Measure Formula

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.

 

REGIONAreaMain SiteAUPEC DefinitionPhysical or Travel
EAST COASTKTKTINSTEPphysically on-site
EAST COASTKTKTINSTEPphysically on-site
EAST COASTKTKTKLCCUHphysically on-site
EAST COASTPakaKIPC KIPCphysically on-site
EAST COASTPakaKIPC KIPCphysically on-site
EAST COASTPakaKIPC KIPCphysically on-site
EAST COASTPakaKIPC KIPCphysically on-site
EAST COASTPakaKIPC KIPCphysically on-site
EAST COASTPakaKIPC KIPCphysically on-site
EAST COASTPakaKIPC KIPCphysically on-site
EAST COASTPakaKIPC PCLDPEphysically on-site
EAST COASTPakaKIPC PCLDPEphysically on-site
EAST COASTPakaKIPC PCLDPEphysically on-site
WEST COASTSabahKimanisKimanisrequire engineer to travel
WEST COASTSabahKimanisKimanisrequire engineer to travel
WEST COASTSabahKimanisKimanisrequire engineer to travel
WEST COASTSabahKimanisKimanisrequire engineer to travel
CENTRALKuala LumpurEtiqaEtiqarequire engineer to travel
CENTRALKuala LumpurEtiqaEtiqarequire engineer to travel
CENTRALKuala LumpurEtiqaEtiqarequire engineer to travel
CENTRALKuala LumpurEtiqaEtiqarequire engineer to travel
CENTRALKuala LumpurEtiqaEtiqarequire engineer to travel
CENTRALKuala LumpurBinjaiBinjairequire engineer to travel
CENTRALKuala LumpurIntermarkIntermarkrequire engineer to travel
CENTRALKuala LumpurIntermarkIntermarkrequire engineer to travel
CENTRALKuala LumpurIntermarkIntermarkrequire engineer to travel
CENTRALKuala LumpurIntermarkIntermarkrequire engineer to travel
CENTRALKuala LumpurIntermarkIntermarkrequire engineer to travel
1 ACCEPTED SOLUTION
Resolver II
Resolver II

Hi @Zaky ,

MEASURE1 = DISTINCTCOUNT( 'Table'[AUPEC Definition] )

 

Capture.JPG

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.

View solution in original post

3 REPLIES 3
Resolver II
Resolver II

Hi @Zaky ,

MEASURE1 = DISTINCTCOUNT( 'Table'[AUPEC Definition] )

 

Capture.JPG

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.

View solution in original post

Hi @RobinDeFal ,

 

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"?
 
capture1.JPG

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

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors