Forum Discussion
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 ...
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