cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors