New table from existing column and measure

[jenani_user]

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

Thanks,

Jen

[v-yiruan-msft]

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

[lbendlin]

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.