Forum Discussion

abhiram342's avatar
abhiram342
Microsoft Employee
6 years ago

RankX function across multiple Dimension Tables

Hi All,

 

I have two dimension tables and one fact table . I have Product Table (Dimension) , Customer Table ( Dimesnion)  and Sales table (Fact). For Each Product, I would like display Top 3 Customer based on Sales.

 

Output is Table Chart:

Product A   Customer1 $100

ProductA    Customer2  $200

ProductA   Cusotmer3  $300

 

Can you please help how to acheive using DAX in Power BI

 

Thanks,

Abhiram

 

7 Replies