Selected Month Value for all Months

[Anonymous]

Gentlemen, good afternoon.

I would like that in a table that appears every month, it was possible to create an average that would bring the result of a selected month for all the months in the table, I would like to send an example of how I would like it to be done and another one with a few attempts.

[Anonymous]

@colacan , the expected result should be this!

[v-yingjl · Accepted solution]

Hi @Anonymous ,

Basically the DS_MES_ABR column should comes from another table so that you can create a measure like this:

Select = 
CALCULATE (
    SUM ( dim_calendario[Realizado] ),
    FILTER (
        ALL ( dim_calendario ),
        'dim_calendario'[DS_MES] = SELECTEDVALUE ( 'Table'[DS_MES] )
    )
)

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi! @colacan ,

I did as you suggested, but it had no effect!!!

[colacan]

@Anonymous  Hi,

VAR Selected_Month = SELECTEDVALUE(dim_calendario[DS_MES_ABREVIADO])

RETURN Calculate([Validacao], dim_calendario[DS_MES_ABREVIADO] = Selected_Month)

Thanks,

Please mark this as soluntion if this helped you.