using metric data i need create reports

[Aruna_ln]

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

[v-jiascu-msft]

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

[v-jiascu-msft]

@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