Forum Discussion

RicardoLeivaG's avatar
RicardoLeivaG
Helper I
6 years ago
Solved

Ayuda con indicador variable

Hola comidad tengo el siguiente tema, tengo una medida rapida creada que calcula un procentaje   % Contribucion = DIVIDE(SUM('det_factura20062020'[contribucion]); 140000000)   esto solo funciona...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    You could set that store that in a variable, and multiple that by the count of selected values.  However, an easier way might be a measure like this one:

     

    Avg Monthly % Contribution = Averagex(Values(Table[Month]), [% Contribucion])

     

    This will calculate the % Contribution for each month and give you the average value.

     

    If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

You could set that store that in a variable, and multiple that by the count of selected values.  However, an easier way might be a measure like this one:

 

Avg Monthly % Contribution = Averagex(Values(Table[Month]), [% Contribucion])

 

This will calculate the % Contribution for each month and give you the average value.

 

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat