Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Transform calculated column into measure

Good afternoon

I need to transform measure "Matriculaciones_cp", which is taken from a calculated column "Matric. zona_Relacionado" which in turn comes out of another calculated coplumna "Matric. zona_Total", in a pure measure, that allows me to use slicers so that the visualization filters me by month and year.

Below I share the simplified .pbix.

https://grupotecsa-my.sharepoint.com/:u:/g/personal/mercedes_morales_grupo-tecsa_com/EfnVZMSD8aVJhx5lSUg-eaIBVv6JD8WeT4PyETIbSGuIzg?e=RS3B33

I hope you can help me.

Thank you very much and greetings,

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    From the sample file it looks like you already did that.  It's a measure and it is impacted by the calendar table.  What else is required?

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    3 years ago

    @lbendlin

    I need the measure to be filtered with month and year slicering. I think it doesn't work because I've taken it from warm columns, but I don't know how to get to the value I'm looking for in another way.