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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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