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 engi...
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.

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