Create Virtual Table

[Abhilash_P]

I have created below table visual using dim_common name  dimension table and Total is a measue refrerring to mutiple table 

How can i create a virtkual table with top 10 values 
Tried using Summarize or calculate table but not working

[amitchandak]

@Abhilash_P , You can have a common name and TOPN measure in visual

CALCULATE([Total_],TOPN(10,all(Table[common name]),[Total_],DESC),VALUES(Table[common name]))

TOPN: https://youtu.be/QIVEFp-QiOk

[Abhilash_P]

Hi @amitchandak ,
Thanks for the reply but i want to create 8 card visuals with top1, 2,3,...8 values in each card visual how can i achive this..?

Regards

Abhilash.P

[Abhilash_P · Accepted solution]

Created below measure my problem is resolved

Var Total_ =calcualted(sum(Fact_sales[Sales]))

Return 
 RANKX(ALL('Dim Banks'[Common Name]),[Total_])