Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Syndicate_Admin
Administrator
Administrator

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/EfnVZMSD8aVJhx5...

I hope you can help me.

Thank you very much and greetings,

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

@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.

lbendlin
Super User
Super User

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?

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.