Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Last 5 years

Hello! I need if you can help me with the measure "% last 5" where I am trying to get the average percentage of the last accounting years, (Ejcontable column), the measure I use is as follows: % l...
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Syndicate_Admin ,

    In the EjContable column of other IDs, are there also these numbers 52, 53, 54, 55, 56? If so, tweak your formula to:

    % last 5 =
VAR _max =
    MAX ( data[EjContable] )
VAR _min = _max - 4
RETURN
    CALCULATE (
        [_participacion],
        FILTER (
            ALLSELECTED ( data ),
            data[EjContable] >= _min
                && data[EjContable] <= _max
        ),
        REMOVEFILTERS ( data[EjContable] )
    )

    In your formula, the ALL function take all ID into consideration, replace it to ALLSELECTED to try.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

As I can not attach the pbi I add more information

_participacion = DIVIDE([Tn Client],[Tn Exercise])
Tn Client = CALCULATE(SUM(date[TON])
Tn Exercise = CALCULATE (SUM(date[TON]),REMOVEFILTERS(data[Id]))
Thank you.