Forum Discussion

Justas4478's avatar
Justas4478
Icon for Post Prodigy rankPost Prodigy
2 years ago

Creating group by measure using existing measure

Hi, I have this measure which count shorted qty and gives number of days item was shorted. Days Shorted = VAR _Table =     SUMMARIZE(          'Outbound Delivery',          'Product Category'[...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
2 years ago

Hi Justas4478 ,

 

since you are in live connection you need to create a measure for each of your calculation try to add a measure for each of your calculations:

 

1 days = 
        VAR temp_table = SUMMARIZE(
			'Outbound Delivery',
			'Outbound Delivery'[Gate/Floor],
			'Outbound Delivery'[SKU Number],
			"Days", [Days Shorted]
		)
		RETURN

			COUNTROWS(FILTER(
				temp_table,
				[Days] = 1
			)

			)

 Just replace the 1 by the number of days you need and then on the matrix visualization put values on rows: