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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jenani_user
Frequent Visitor

New table from existing column and measure

Hi Team,

 

I have a table with region and teams,value is a calculated measure based on few conditions, I can visualize those fields but I need to store those as a table in powerbi, Is there any possibility to create table with existing column and measure from same table

jenani_user_0-1706869943184.png

 

Thanks,

Jen

 

2 REPLIES 2
v-yiruan-msft
Community Support
Community Support

Hi @jenani_user ,

Based on your description it seems like you are trying to store the value obtained from meaure in a table. As @lbendlin said, you might be able to create calculated tables to store this value, but you have to realize that computed tables don't change with filters and slicers. So it may not be possible to store the correct value in the table. May I know where you want to apply this meaure value later? Could you please provide me with some example data, the formula for the measure and the final result you want to achieve? That way we can see if there is another workaround that can accomplish what you want... You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

 

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lbendlin
Super User
Super User

You can technically create calculated tables but most likely the result will be wrong as measures depend on filter context which you don't have in that situation.  The general rule is that you cannot (should not) create calculated columns or tables from measures.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.