Wrong Measure Result

Question

Hello everybody,&nbsp;I'm struggling with some measures.&nbsp;My model is ambigous however i can get everything i need for now.&nbsp;here is my model with black arrows to show were are the bidirectionnal links.&nbsp;&nbsp;My measures are working very well, but i have sometimes a wrong calculation result on a measure.&nbsp;The goal to achieve Is to transfer items from one warehouse to another where the items are authorized to Go (represented by The RANK of "TABLEAU DISPATCH" Table) Where a number says OK and priority goes from 1 (most important) to x (number of warehouses authorized)&nbsp;&nbsp;Heres the result with one correct Item&nbsp; and one incorrect item (in the same table.&nbsp;&nbsp;&nbsp;CODE ARTICLELIBELLE ARTICLERank for dispatchQuantity by Size(1) Final SplitQuantity movementWarehouse codeItems in stock by size (not used)(1)Residual quantities&nbsp;(1) Attribution of residualsFrom Base Article tableFrom Base article tableFrom Tableau dispatch tableFrom Stock dispo full tableMeasuremeasureFrom dépots et établissements tablenot used (Sum of Stock dispofull[Quantites physiques]Measure (Take numbers after Decimals when division on Quantities / Total number of Warehouses) Take decimals multiplied by Number of warehousesMeasure : If (1) Residual quantities are greater or Equal to Rank Then 1&nbsp;AAAA2121010/0&nbsp;&nbsp;AAAA152-3015/0&nbsp;&nbsp;AAAA3&nbsp;22040/0&nbsp;&nbsp;BBBB222 (error) =&gt; 3 (ok)0010/2Should have 1 here&nbsp;BBBB163-3015/21&nbsp;BBBB3&nbsp;22040/2&nbsp;&nbsp;For Item AAAA It works Great&nbsp;However For Item BBBB&nbsp;&nbsp;The Items in Quantity by size Show 8 in total (2+6) And column total is OK (8)&nbsp;Then for (1) Répartition Finale It shows only 4 in Column Total and one quantity is not added from last column (1)Attribution des reliquats&nbsp;Anybody can help me on this?&nbsp;🙂&nbsp;

greg_deckler · Answer

SebSchoon1&nbsp;Sorry, having trouble following, can you post sample data as text and expected output?Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882Also, 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/38490The most important parts are:1. Sample data as text, use the table tool in the editing bar2. Expected output from sample data3. Explanation in words of how to get from 1. to 2.

sebschoon1 · Answer

Greg_Deckler&nbsp;&nbsp;Hello,&nbsp;Thank you for your answer!&nbsp;I have created the exact table I'd like&nbsp;&nbsp;&nbsp;Here the link for a Sample&nbsp;https://we.tl/t-S4p7rDPTpc&nbsp;The measure does not work for each items and i don't no why exactly.&nbsp;It must simply distibute the items to different warehouses according to priority&nbsp;I one warehouse Have 6 Items and the two other ones have 1 item&nbsp; ==&gt; Total 7 Items For 3 warehouses&nbsp;Rank&nbsp; 1 , 2 , 3&nbsp;&nbsp;3 items in rank 12 items in rank 22 items in rank 2&nbsp;and this for each Items ( even the one with different Sizes [TAILLE] in base article.&nbsp;Kind regards,&nbsp;&nbsp;

greg_deckler · Answer

SebSchoon1&nbsp;Will have to take a closer look. FIFO/LIFO/where order matters can get tricky. In the mean time, this might help you.&nbsp;(3) Delivery Dates - Microsoft Power BI Community

sebschoon1 · Answer

Hi, Greg_Deckler&nbsp;&nbsp;Any advice ?

Forum Discussion

Wrong Measure Result

4 Replies

Related content

Comparing measures with wrong result

Wrong Total result of Measure

Subtotals showing wrong results

CountRow return wrong result

DAX Measure Returning Incorrect Results

CODE ARTICLE	LIBELLE ARTICLE	Rank for dispatch	Quantity by Size	(1) Final Split	Quantity movement	Warehouse code	Items in stock by size (not used)	(1)Residual quantities	(1) Attribution of residuals
From Base Article table	From Base article table	From Tableau dispatch table	From Stock dispo full table	Measure	measure	From dépots et établissements table	not used (Sum of Stock dispofull[Quantites physiques]	Measure (Take numbers after Decimals when division on Quantities / Total number of Warehouses) Take decimals multiplied by Number of warehouses	Measure : If (1) Residual quantities are greater or Equal to Rank Then 1
	AAAA	2	1	2	1	010	/	0
	AAAA	1	5	2	-3	015	/	0
	AAAA	3		2	2	040	/	0
	BBBB	2	2	2 (error) => 3 (ok)	0	010	/	2	Should have 1 here
	BBBB	1	6	3	-3	015	/	2	1
	BBBB	3		2	2	040	/	2