Forum Discussion

Aruna_ln's avatar
Aruna_ln
Icon for Helper III rankHelper 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   ...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft 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