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.

Regular Visitor

Ranked Calculated Table



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. 



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



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.

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

Solution Supplier
Solution Supplier

Hello @rosh 


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




Please use the above mentioned column and table names

Helpful resources

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