Measure Total Not Correct Using MIN Function

[hworrall]

I am using the MIN fuction to find the smaller of two numbers.  In my table, it shows a blank as the result for one client, but the total includes the number that is actually the higher of the two.  

Here is my calculation:  

WIPOver90Days_2 = MIN(CALCULATE(sum(WIP[Wfee]),filter((WIP),(WIP[Windicator]="P"))),CALCULATE(WIP[WipExpWindicator is W]+WIP[WipFeeWindicator is W],filter((WIP),WIP[WIPAgeDays] > 90)))

Here is my result.  The $500 is the value of the first part of the MIN calculation (where the Windicator = P).  There is no data for the second calculate option.

Cltnum		WIPOver90Days_2
60482.120
60482.102		0
60482.106		0
60482.109		0
60482.105
60482.107
60482.500
Total:		$500

I am spinning my wheels with this one!  Any help is appreciated.

[v-deddai1-msft]

Hi @hworrall,

What did you want for total value? If you want to show smallest value in [WIPOver90Days_2], please refer to the measure :

WIPOver90Days_2 FOR VISUAL =
IF (
    HASONEVALUE ( WIP[Cltnum] ),
    [WIPOver90Days_2],
    MINX ( SUMMARIZE ( WIP, WIP[Cltnum],WIP[WEng], "_MIN", [WIPOver90Days_2] ), [_MIN] )
)

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

Best Regards,

Dedmon Dai

[hworrall]

Unfortunately this is giving me the same result.  The resulting table doesn't show the $500, but does include it in the sum.  Here is the data if it is helpful.

WCltNum	WEng	Wfee	Windicator		WCltNum	WEng	Wfee	Windicator
60482	102		W		60482	102	0	P
60482	105	340	W		60482	105		P
60482	106		W		60482	106	0	P
60482	107	3966.9	W		60482	107		P
60482	109		W		60482	109	0	P
60482	120		W		60482	120	500	P
60482	500	19.34	W		60482	500		P

And here is the resulting table:

Cltnum	WEng	WIPOver90Days_2	WIPOver90Days_2 FOR VISUAL
60482	120
60482	102	0	0
60482	106	0	0
60482	109	0	0
60482	105
60482	107
60482	500
Total		500	500

The total should be 0.

[v-deddai1-msft]

Hi @hworrall ,

I have edited my original reply. Please try again.

Best Regards,

Dedmon Dai

[hworrall]

Somehow it is still giving the $500 as the total even though the results in the table are correct.  I am going to go back and try to work on this from scratch and see if I can come up with something.

Thanks for your help!

[v-deddai1-msft · Accepted solution]

Hi @hworrall ,

Would you please try the following measure:

WIPOver90Days_2 FOR VISUAL =
IF (
    HASONEVALUE ( WIP[WEng] ),
    [WIPOver90Days_2],
    MINX ( SUMMARIZE ( WIP, WIP[Cltnum],WIP[WEng], "_MIN", [WIPOver90Days_2] ), [_MIN] )
)

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

Best Regards,

Dedmon Dai