topic Re: Counting Measure Results in DAX Commands and Tips

Counting Measure Results

Nestor_Moreno — Wed, 28 Oct 2020 16:54:58 GMT

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 (this is a information about work, when start, where, what he doing, etcc )
Medidas (this is a measure table)

I need to know how many workers stay in the work after 90 days.

In my measure table (Table3), i have 3 measures:

Date to starts to work:
- Fecha_Vinculacion = MAX(Vinculacion[Fecha_Vinculacion_Ok])
Date to finish to work:
- Fecha_Finalizo_Proceso = MIN(Reg_Beneficiario_Empleabilidad[Fecha_Finalizo_Proceso_Ok])
Working Days:
- Dias_Vinculación = IF(ISBLANK([Fecha_Finalizo_Proceso]),VALUE(TODAY())-VALUE([Fecha_Vinculacion]),VALUE([Fecha_Finalizo_Proceso])-VALUE([Fecha_Vinculacion]))

I Show this in a table:

Now, my problem is, that i need to know how many workers stay in the work after 90 days.

How i can count how many registers are >= to 90 days if this is a measure.

Thanks for your valuable help.

Regards.

Re: Counting Measure Results

AlB — Wed, 28 Oct 2020 22:01:12 GMT

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

Re: Counting Measure Results

Nestor_Moreno — Thu, 29 Oct 2020 12:07:26 GMT

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

Re: Counting Measure Results

AlB — Fri, 30 Oct 2020 10:25:14 GMT

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