Forum Discussion
Helper Vtop 5 VALUES by month
Super UserHi,
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.
Helper Vi have a demo file. How do i attach it?
- Jihwan_Kim
Hi,
Please share the link of the pbix file.
You can try to use onedrive, googledrive, or dropbox to share the link.
Thanks.
- PPStar
https://drive.google.com/file/d/1E1BQCz6HY3xgmUo3LePYUG8OarQG1M7y/view?usp=sharing
can you access the file via that link?
Note
Consumer Usage is the measure i am using. We only want to see Consumer Usage of items. Therefore the consumer usage is te metric we are measuring against. So we want to see top 5 consumer used item by Month.
Thanks
- Jihwan_Kim
Hi,
Thank you for sharing.
However, it is difficult for me to understand the data model.
- Where can I find consumers information?