Forum Discussion

Nestor_Moreno's avatar
Nestor_Moreno
Frequent Visitor
5 years ago
Solved

Counting Measure Results

Hello community,   I need count the results of a measure, i try to explain my problem.   I have 3 tables: Reg_Beneficiario_Empleabilidad (this is a personal information of workers) Vinculacion...
  • AlB's avatar
    AlB
    5 years ago

    Nestor_Moreno 

    Place this measure in the same visual and you'll have the sum at the total row (and 1 or zero in each of the other rows depending on if the employee has or not been with the company for > 90 days)

    New Measure Total V2 =
SUMX (
    DISTINCT ( Reg_Beneficiario_Empleabilidad[ID beneficiario] ),
    ([Dias_Vinculación]> 90) * 1
)

    Or you can just place it in a card visual to have the total on it 

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

AlB's avatar
AlB
Community Champion
5 years ago

Hi Nestor_Moreno 

Try this measure that uses the one you already have. Place it in the visual:

New Measure Total =
SUMX (
    DISTINCT ( Reg_Beneficiario_Empleabilidad[ID beneficiario] ),
    [Dias_Vinculación]
)

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

  • Nestor_Moreno's avatar
    Nestor_Moreno
    Frequent Visitor
    5 years ago

    Hi AlB ,

     

    Thanks for your answer, but how i Could count the workers that have more of 90 days in the work (Dias_Vinculación)?

     

    With your formula are adding up. 

     

    Thanks for your help. 

     

    Regards

     

     

    • AlB's avatar
      AlB
      Community Champion
      5 years ago

      Nestor_Moreno 

      Place this measure in the same visual and you'll have the sum at the total row (and 1 or zero in each of the other rows depending on if the employee has or not been with the company for > 90 days)

      New Measure Total V2 =
SUMX (
    DISTINCT ( Reg_Beneficiario_Empleabilidad[ID beneficiario] ),
    ([Dias_Vinculación]> 90) * 1
)

      Or you can just place it in a card visual to have the total on it 

       

      Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

      Contact me privately for support with any larger-scale BI needs, tutoring, etc.

      Cheers