Forum Discussion

Aruna_ln's avatar
Aruna_ln
Helper III
9 years ago

using metric data i need create reports

hi any body help

 

using usage metric i need create reports.that also publish(the reports is most viwed 5 reports )

 

or

i need download data in excel or Database then i need create reports

 

plase anybody help how create this reports using usage metrics data

 

thanks

aruna

Need Help

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    Aruna_ln

     

    Hi,

     

    Maybe you could try dax function "RANKX" and "TOPN". "RANKX" may be like this:

    Measure =
RANKX ( ALL ( 'Product'[Brand] ), CALCULATE ( SUM ( Sales[Quantity] ) ) )

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

     

     

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    Hi Aruna_ln,

     

    Could you please mark the proper post as answer if it worked? More about this topic, please feel free to post here.

    Best Regards!
    Dale