Multiplication data issue

[Anonymous]

Hi Everyone,

I am using below measure to get value but value not matching. Could you please help me!

Z_BB = [Z_GPH]*[Z_Nominal Speed_Measure]*ai_targets[AI Target]

Ai Target % is one tabe and caluclation is

DIVIDE(Merge1[Measure_GPT],Merge1[Measure_OT]) and

remaining coming from other table and i did merge. With merge i have used all kind of joins but not getting expected output

[Z_GPH]=sum(gph)

[Z_Nominal Speed_Measure]=divide(sum(quantity),sum(th)) it is just decimal number

Final measure not getting expected output. Could you please help me where it went wrong.

Cardinality between the tables is m:m

Regards,

Venkat

[Anonymous]

I have used custom columns and able to see inlcuding all decimal places and hence issue resolved. there is no issue with my calculation

[v-angzheng-msft]

Hi, @Anonymous 

It is not easy to judge the cause of the problem based on the measure formula alone, and no one can know where there is an easily overlooked detail that causes the problem to occur. 

If possible, please consider sharing more details about it and posting expected result so it is clear on what needs to be implemented.  And It would be great if there is a sample file without any sesentive information here.

It makes it easier to give you a solution.

1. Sample (dummy dataset) data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , multiplication should be done at row level, if possible. like inside sumx/minx etc or create a new column

else push a group by

like

sumx(values(dim[Dim1]), [measure from fact1]*[Measure from fact2] )

[Anonymous]

@amitchandak I have tried with your idea but still not working as expected. I have created and tried using both measure and calculated column but no still no luck and even with the measure i breakdown the small pieces but not working. Could you please let me know if you have thoughts or correct me if iam wrong

Column 2 = SUMX(V_PBI_DTA_SAM_Daily_Region,SUM(V_PBI_DTA_SAM_Daily_Region[GPH])*(SUM(V_PBI_DTA_SAM_Daily_Region[PEHQTYEach])/SUM(V_PBI_DTA_SAM_Daily_Region[TH]))*SUM(ai_targets[GPT])/SUM(ai_targets[OT]))

Regards,

Venkat

[Anonymous]

any quick suggestion please.

[Anonymous · Accepted solution]

Here is some sample data 

Region Sample Data

Resource/Plant	DayDate	GPH	PEHQTYEach	TH
WF03/PE74005	1/17/2021	0	0	0
WF03/PE74005	1/18/2021	0	0	0
WF03/PE74005	1/19/2021	0	0	0
WF03/PE74005	1/20/2021	0	0	0
WF03/PE74005	1/21/2021	0	0	0
WF03/PE74005	1/22/2021	0	0	0
WF03/PE74005	1/23/2021	0	0	0
WF03/PE74005	1/24/2021	0	0	0
WF03/PE74005	1/25/2021	0	0	0
WF03/PE74005	1/26/2021	720	230400	384
WF03/PE74005	1/27/2021	1440	585600	976
WF03/PE74005	1/28/2021	1440	627840	1046.4
WF03/PE74005	1/29/2021	1140	505440	842.4
WF03/PE74005	1/30/2021	1440	630864	1051.44
WF03/PE74005	1/31/2021	1290	561600	936
WF03/PE74005	2/1/2021	12	7488	12.48
WF03/PE74005	2/2/2021	0	0	0
WF03/PE74005	2/3/2021	0	0	0
WF03/PE74005	2/4/2021	0	0	0
WF03/PE74005	2/5/2021	0	0	0
WF03/PE74005	2/6/2021	0	0	0
WF03/PE74005	2/7/2021	0	0	0
WF03/PE74005	2/8/2021	0	0	0
WF03/PE74005	2/9/2021	0	0	0
WF03/PE74005	2/10/2021	0	0	0
WF03/PE74005	2/11/2021	0	0	0
WF03/PE74005	2/12/2021	0	0	0
WF03/PE74005	2/13/2021	0	0	0
WF03/PE74005	2/14/2021	0	0	0
WF03/PE74005	2/15/2021	0	0	0
WF03/PE74005	2/16/2021	0	0	0
WF03/PE74005	2/17/2021	0	0	0
WF03/PE74005	2/18/2021	0	0	0
WF03/PE74005	2/19/2021	0	0	0
WF03/PE74005	2/20/2021	0	0	0
WF03/PE74005	2/21/2021	0	0	0
WF03/PE74005	2/22/2021	0	0	0
WF03/PE74005	2/23/2021	0	0	0
WF03/PE74005	2/24/2021	0	0	0
WF03/PE74005	2/25/2021	0	0	0
WF03/PE74005	2/26/2021	0	0	0
WF03/PE74005	2/27/2021	0	0	0
WF03/PE74005	2/28/2021	0	0	0
WF03/PE74005	3/1/2021	0	0	0
WF03/PE74005	3/2/2021	0	0	0
WF03/PE74005	3/3/2021	840	284544	474.24
WF03/PE74005	3/4/2021	1440	666432	1110.72
WF03/PE74005	3/5/2021	3	1584	2.64
WF03/PE74005	3/6/2021	0	0	0
WF03/PE74005	3/7/2021	0	0	0
WF03/PE74005	3/8/2021	0	0	0
WF03/PE74005	3/9/2021	0	0	0
WF03/PE74005	3/10/2021	0	0	0
WF03/PE74005	3/11/2021	0	0	0
WF03/PE74005	3/12/2021	1440	393600	656
WF03/PE74005	3/13/2021	1380	626640	1044.4
WF03/PE74005	3/14/2021	1440	732360	1220.6
WF03/PE74005	3/15/2021	1440	725760	1209.6
WF03/PE74005	3/16/2021	1440	687360	1145.6
WF03/PE74005	3/17/2021	1440	741120	1235.2
WF03/PE74005	3/18/2021	0	0	0
WF03/PE74005	3/19/2021	0	0	0
WF03/PE74005	3/20/2021	0	0	0
WF03/PE74005	3/21/2021	0	0	0
WF03/PE74005	3/22/2021	0	0	0
WF03/PE74005	3/23/2021	0	0	0
WF03/PE74005	3/24/2021	0	0	0
WF03/PE74005	3/25/2021	0	0	0
WF03/PE74005	3/26/2021	0	0	0
WF03/PE74005	3/27/2021	0	0	0
WF03/PE74005	3/28/2021	0	0	0
WF03/PE74005	3/29/2021	0	0	0
WF03/PE74005	3/30/2021	0	0	0
WF03/PE74005	3/31/2021	0	0	0
WF03/PE74005	4/1/2021	0	0	0
WF03/PE74005	4/2/2021	0	0	0
WF03/PE74005	4/3/2021	0	0	0
WF03/PE74005	4/4/2021	0	0	0
WF03/PE74005	4/5/2021	0	0	0
WF03/PE74005	4/6/2021	0	0	0
WF03/PE74005	4/7/2021	0	0	0
WF03/PE74005	4/8/2021	0	0	0
WF03/PE74005	4/9/2021	0	0	0
WF03/PE74005	4/10/2021	0	0	0
WF03/PE74005	4/11/2021	0	0	0
WF03/PE74005	4/12/2021	0	0	0
WF03/PE74005	4/13/2021	0	0	0
WF03/PE74005	4/14/2021	0	0	0
WF03/PE74005	4/15/2021	0	0	0
WF03/PE74005	4/16/2021	720	247680	412.8
WF03/PE74005	4/17/2021	1350	541440	902.4
WF03/PE74005	4/18/2021	1440	520320	867.2
WF03/PE74005	4/19/2021	1440	472176	786.96
WF03/PE74005	4/20/2021	1440	670080	1116.8
WF03/PE74005	4/21/2021	1440	716160	1193.6
WF03/PE74005	4/22/2021	1380	541440	902.4
WF03/PE74005	4/23/2021	1290	322560	537.6
WF03/PE74005	4/24/2021	1260	416224	693.7067
WF03/PE74005	4/25/2021	1380	572160	953.6

Ai Targets Sample Data

Resource	Date	GPT	OT
WF00/IP73601	1/1/2022	0.72	1
WF00/IP73601	2/1/2022	0.72	1
WF00/IP73601	3/1/2022	0.72	1
WF00/IP73601	4/1/2022	0.72	1
WF00/IP73601	5/1/2022	0.72	1
WF00/IP73601	6/1/2022	0.72	1
WF00/IP73601	7/1/2022	0.72	1
WF00/IP73601	8/1/2022	0.72	1
WF00/IP73601	9/1/2022	0.72	1
WF00/IP73601	10/1/2022	0.72	1
WF00/IP73601	11/1/2022	0.72	1
WF00/IP73601	12/1/2022	0.72	1
WF00/IP73601	1/1/2020	424.5739	603.6271
WF00/IP73601	2/1/2020	395.1713	545.2116
WF00/IP73601	3/1/2020	443.1202	603.6271
WF00/IP73601	4/1/2020	510.4574	674.0253
WF00/IP73601	5/1/2020	568.6874	742.9256
WF00/IP73601	6/1/2020	584.739	763.8953
WF00/IP73601	7/1/2020	604.2303	789.3585
WF00/IP73601	8/1/2020	597.8024	789.3585
WF00/IP73601	9/1/2020	544.4879	718.9603
WF00/IP73601	10/1/2020	521.8009	696.4928
WF00/IP73601	11/1/2020	504.9686	674.0253
WF00/IP73601	12/1/2020	521.8009	696.4928
WF00/IP73601	1/1/2021	498.062	625.667
WF00/IP73601	2/1/2021	498.062	625.667
WF00/IP73601	3/1/2021	498.062	625.667
WF00/IP73601	4/1/2021	498.062	625.667
WF00/IP73601	5/1/2021	498.062	625.667
WF00/IP73601	6/1/2021	498.062	625.667
WF00/IP73601	7/1/2021	498.062	625.667
WF00/IP73601	8/1/2021	498.062	625.667
WF00/IP73601	9/1/2021	498.062	625.667
WF00/IP73601	10/1/2021	498.062	625.667
WF00/IP73601	11/1/2021	498.062	625.667
WF00/IP73601	12/1/2021	498.062	625.667
WF00/IP73601	1/1/2022	455.895	569.244
WF00/IP73601	1/2/2022	455.895	569.244
WF00/IP73601	1/3/2022	455.895	569.244
WF00/IP73601	1/4/2022	455.895	569.244
WF00/IP73601	1/5/2022	455.895	569.244
WF00/IP73601	1/6/2022	455.895	569.244
WF00/IP73601	1/7/2022	455.895	569.244
WF00/IP73601	1/8/2022	455.895	569.244
WF00/IP73601	1/9/2022	455.895	569.244
WF00/IP73601	1/10/2022	455.895	569.244
WF00/IP73601	1/11/2022	455.895	569.244
WF00/IP73602	1/12/2022	455.895	569.244
WF00/IP73602	2/1/2022	455.895	569.244
WF00/IP73602	3/1/2022	455.895	569.244
WF00/IP73602	4/1/2022	455.895	569.244
WF00/IP73602	5/1/2022	455.895	569.244
WF00/IP73602	6/1/2022	455.895	569.244
WF00/IP73602	7/1/2022	455.895	569.244
WF00/IP73602	8/1/2022	455.895	569.244
WF00/IP73602	9/1/2022	455.895	569.244
WF00/IP73602	10/1/2022	455.895	569.244
WF00/IP73602	11/1/2022	455.895	569.244
WF00/IP73602	12/1/2022	455.895	569.244
WF00/IP73602	1/1/2020	733.501	944.5704
WF00/IP73602	2/1/2020	313.847	455.0188
WF00/IP73602	3/1/2020	353.6447	503.7709
WF00/IP73602	4/1/2020	398.6181	548.4602
WF00/IP73602	5/1/2020	468.5036	629.7136
WF00/IP73602	6/1/2020	559.7107	731.2803
WF00/IP73602	7/1/2020	586.8008	755.6563
WF00/IP73602	8/1/2020	583.9671	755.6563
WF00/IP73602	9/1/2020	558.4017	731.2803
WF00/IP73602	10/1/2020	570.7432	755.6563
WF00/IP73602	11/1/2020	545.6775	731.2803
WF00/IP73602	12/1/2020	562.0338	755.6563
WF00/IP73602	1/1/2021	174.358	238.116
WF00/IP73602	2/1/2021	174.358	238.116
WF00/IP73602	3/1/2021	174.358	238.116
WF00/IP73602	4/1/2021	174.358	238.116
WF00/IP73602	5/1/2021	174.358	238.116
WF00/IP73602	6/1/2021	174.358	238.116
WF00/IP73602	7/1/2021	174.358	238.116
WF00/IP73602	8/1/2021	174.358	238.116
WF00/IP73602	9/1/2021	174.358	238.116
WF00/IP73602	10/1/2021	174.358	238.116
WF00/IP73602	11/1/2021	174.358	238.116
WF00/IP73602	12/1/2021	174.358	238.116
WF00/IP73602	1/1/2022	300.748	411.338
WF00/IP73602	1/2/2022	300.748	411.338
WF00/IP73602	1/3/2022	300.748	411.338
WF00/IP73602	1/4/2022	300.748	411.338
WF00/IP73602	1/5/2022	300.748	411.338
WF00/IP73602	1/6/2022	300.748	411.338
WF00/IP73602	1/7/2022	300.748	411.338
WF00/IP73602	1/8/2022	300.748	411.338
WF00/IP73602	1/9/2022	300.748	411.338
WF00/IP73602	1/10/2022	300.748	411.338
WF00/IP73602	1/11/2022	300.748	411.338
WF00/IP73603	1/12/2022	300.748	411.338
WF00/IP73603	2/1/2022	300.748	411.338
WF00/IP73603	3/1/2022	300.748	411.338
WF00/IP73603	4/1/2022	300.748	411.338
WF00/IP73603	5/1/2022	300.748	411.338
WF00/IP73603	6/1/2022	300.748	411.338
WF00/IP73603	7/1/2022	300.748	411.338
WF00/IP73603	8/1/2022	300.748	411.338
WF00/IP73603	9/1/2022	300.748	411.338
WF00/IP73603	10/1/2022	300.748	411.338
WF00/IP73603	11/1/2022	300.748	411.338