Forum Discussion
Solved
Create Virtual Table
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
Created below measure my problem is resolved
Var Total_ =calcualted(sum(Fact_sales[Sales]))Return
RANKX(ALL('Dim Banks'[Common Name]),[Total_])
3 Replies
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]))
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
Created below measure my problem is resolved
Var Total_ =calcualted(sum(Fact_sales[Sales]))Return
RANKX(ALL('Dim Banks'[Common Name]),[Total_])
