Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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
@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
@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.
@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.