Count the Number of Order Quantity per Material Number value per Month

[Anonymous]

Hi everyone,

 I've found a way to show a list of Part Numbers by using this:

List of Part Numbers = 
VAR __DISTINCT_VALUES_COUNT = DISTINCTCOUNT('full updated ALL PARTS'[Material number])
VAR __MAX_VALUES_TO_SHOW = 50
RETURN
	IF(
		__DISTINCT_VALUES_COUNT > __MAX_VALUES_TO_SHOW,
		CONCATENATE(
			CONCATENATEX(
				TOPN(
					__MAX_VALUES_TO_SHOW,
					VALUES('full updated ALL PARTS'[Material number]),
					'full updated ALL PARTS'[Material number],
					ASC
				),
				'full updated ALL PARTS'[Material number],
				", ",
				'full updated ALL PARTS'[Material number],
				ASC
			),
			",  etc."
		),
		CONCATENATEX(
			VALUES('full updated ALL PARTS'[Material number]),
			'full updated ALL PARTS'[Material number],
			", ",
			'full updated ALL PARTS'[Material number],
			ASC
		)
	)

Here are the columns I have:

Rows in blue are what I want to show in my PBI's bar chart when I hover over any random bars.

More specifically, if there's an order on a certain Part Number in a certain month, return the number of order per that specific part number per that specific month.

Ex: Order Quantity per 3045892-01 = 6 (when hovering the mouse over March for example)

This is what my PBI currently has:

Please could any of you show me how to do this? Thank you very much!! Any helps are so much appreciated!!!

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490