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_]) 


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

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'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_])