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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Create a Calculated Table based off a Measure

Hello - First post here, so apologies if i miss key info.

I have a table which contains a measure where the value is dependent on a slicer and if the value exists in another table. 
What i am looking to do is create an Aggregated version of my original table but aggregated on the measure i have created. 

I have also attached a screenshot of my measure below - Also a bit of the data i am trying to work with.

ArisJamesM_0-1632918302063.png

 

Happy to supply any and all information. 

Thank you in advance.

6 REPLIES 6
VahidDM
Super User
Super User

HI @Anonymous 

 

Can you please add a sample of your data and result table?

How to Get Your Question Answered Quickly

 

Appreciate your Kudos VahidDM_0-1632919464490.png !!

 

Anonymous
Not applicable

Thank you for the response - This is going to sound stupid, but how would i do that?
Aas some of this data i cannot share, it could make it hard.

 

Remove your sensitive data and create the same table and fill it with some data; more important, create a sample of your result table and share it as well.

just add 4 to 6 line data if that cover your request

 

Appreciate your Kudos!!

Anonymous
Not applicable

I am trying to create a COUNT of UserID's agasint the "Player Category". When i group by Player Category it is only showing ONE Category.
Ideally i am trying to create this as a calculated table - But i am having issues with GROUPING on a measure.

ArisJamesM_0-1632922106671.pngArisJamesM_1-1632922127592.png

 

Anonymous
Not applicable

please download my PBIX file from here:
https://www.filemail.com/d/pxujfxustlaqzvl

Anonymous
Not applicable

Hi what i have done instead, is created a sample PBIX File - Is there anyway i can upload this here?

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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