Forum Discussion

Zaky's avatar
Zaky
Helper IV
6 years ago
Solved

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
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Zaky
      Helper IV
      6 years ago

      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's avatar
        Anonymous
        Not applicable
        6 years ago

        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