Forum Discussion
PPStar
Helper V
3 years agotop 5 VALUES by month
Hi i have the following data Usage | Month Year | Name 123 | Jan 22 | Item A 124 | Jan 22 | Item B 14412 | Jan 22 | Item C 1324 | Feb 22 | ...
Jihwan_Kim
Super User
3 years agoHi,
Thank you for your message.
Please check if Items table has other columns that influence the measure [TotalUsage] in the visualization.
Once the columns are identified, please write the measure something like below.
Top 5 item usage by month: =
CALCULATE (
[Usage measure:],
KEEPFILTERS (
TOPN ( 5,
ALL ( 'Item'[Item],'Item'[columnAinthevisualization],'Item'[columnBinthevisualization], and so forth ), [Usage measure:], DESC )
)
)
Or, if it is OK with you, please share your sample pbix file's link and then I can try to look into it.
Thanks.
PPStar
Helper V
3 years agoThis is what i see, How do i add an .pbix file to this message? If i drag it on, it says file not compatible?