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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
rosh
Regular Visitor

Ranked Calculated Table

Hi 

 

I have a sales transaction table and a customer dimension table. 

I would like to create one calculated table that indicates the rank of the total sales per customer ID, but also include all the dimension columns I would like to add. 

I would then like to be able to use the calculated table in my visuals in order to show top X customers, for all visuals made from the calculated table. With a TopN slicer using the Rank N value, from the calculated table. 

 

Eg. 

Sales Transaction table:

Sales Date, Customer ID, Sales Amount

Customer Dimension table: 

Customer ID, Age, Email, Location, Name

 

Calculated Table:

Sales Rank, Customer ID, Total Sales (based on date selection on overal page), Customer Age, Email, Location, Name

 

Visuals on Page:

Slicer: Sales Rank

 

Table: 

Sales Rank, Customer name, Email, Total Sales

 

Pie Chart:

Customer Age

 

All visuals on the page should update to show the Top N based on the sales rank. As well as only include sales in the calculated table based on the date period selected.

3 REPLIES 3
v-janeyg-msft
Community Support
Community Support

Hello @rosh 

 

I suggest you share your sample data(without privacy), otherwise no one would like to help you.

How to Get Your Question Answered Quickly - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ Janey

sanalytics
Super User
Super User

Hello @rosh 

 

Please share some dummy data so that we can work..

 

Regards

sanalytics

Please use the above mentioned column and table names

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors
Top Kudoed Authors