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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
ArisJamesM
New Member

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

HI @ArisJamesM 

 

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 !!

 

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!!

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

 

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

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

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors