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
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
Solution Supplier
Solution Supplier

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