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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
VahidDM
Super User
Super User

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.