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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
myti
Helper II
Helper II

How to create separate section in Fields pan to put all new measures

Dear Friends,

Hope you are great.

 

I have simple question, How I can create seprated section in "Fields" pan in PI to put all my calculated measure inside.I have attached the sample picture.I would to do like "Fact" section in Fields.

 

Thanks

Regards

Myti

2016-05-11.png

4 REPLIES 4
ankitpatira
Community Champion
Community Champion

@myti You create measure inside your table which in your case is your 'Fact' table (from screenshot). If you want seperate table for all the measures you should in PBI data modelling create a new table and create measures in it.

Thanks @ankitpatira,

Actually, the photo is not snapshot of my PBI.I would to organize my powerbi like this snapshot which is more transparent where the measures are separated from data tables and only are used for creating reports.Currently I created my measures inside each table and I can use them in my reports successfully.Honestly,no idea how I can create a table only including measures?could you tell me which function I can use ?

 

Thank you in advance,

Myti

 

ankitpatira
Community Champion
Community Champion

@myti Under modelling tab you can cretae new tables and then add measures to those tables or columns using MDX queries. You can specify columns from other tables within MDX queries.

 

 

 

 

2016-05-11_19-07-01.png

@ankitpatiraThanks for your fast response.

 

I think you did not get my question well or I may not explain it well. I found my answer in below link.Hope it is useful for others if they are searching for creating table of measures in PBI Desktop.

 

HOW TO DEFINE A MEASURE TABLE IN POWER BI DESKTOP

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors