Forum Discussion

Abhilash_P's avatar
Abhilash_P
Icon for Super User rankSuper User
3 years ago
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  Trie...
Need Help
  • Abhilash_P's avatar
    Abhilash_P
    3 years ago

    Created below measure my problem is resolved

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

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


Abhilash_P's avatar
Abhilash_P
Icon for Super User rankSuper User
3 years ago

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's avatar
Abhilash_P
Icon for Super User rankSuper User
3 years ago

Created below measure my problem is resolved

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

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