Trying to return the first positive min value that isn't zero

[ksmith0411]

Hi, 

I am trying to create a column that will give me the first positive min figure that isnt zero ie I have call data by skill but I want to find the Min queue time from the In SVL col but I dont want it to return zero as the lowest value. As per the data below for this skill I want the min column to return 

Thanks

K

[Anonymous]

Hi @ksmith0411 ,

Please try to create a new column with below dax formula:

Min_In_SVL =
VAR tmp = FILTER ( 'Table', [In SVL] > 0 ) RETURN MINX ( tmp, [In SVL] )

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ksmith0411]

Hi Samarth,

It gave me a number other than zero but still not the min number, for example the data below the min has returned 8 but I would expect it to return 414 

Date	Week	Month	CMS Skill	Cxone Skill	In SVL
01/12/2022	28/11/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	2644
02/12/2022	28/11/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	2238
03/12/2022	28/11/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	1477
04/12/2022	28/11/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	498
05/12/2022	05/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	3530
06/12/2022	05/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	2825
07/12/2022	05/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	2638
08/12/2022	05/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	2424
09/12/2022	05/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	2460
10/12/2022	05/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	1261
11/12/2022	05/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	414
12/12/2022	12/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	2950
13/12/2022	12/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	2572
14/12/2022	12/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	2473
15/12/2022	12/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	2346
16/12/2022	12/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	2603
17/12/2022	12/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	1201
18/12/2022	12/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	419
19/12/2022	19/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	3071
20/12/2022	19/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	2662
21/12/2022	19/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	2711
22/12/2022	19/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	2298
23/12/2022	19/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	1986
24/12/2022	19/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	539
25/12/2022	19/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	0
26/12/2022	26/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	0
27/12/2022	26/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	1332
28/12/2022	26/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	2256
29/12/2022	26/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	2029
30/12/2022	26/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	1374
31/12/2022	26/12/2022	01/12/2022	CS MO BX	HD RTL T CS Motor	856

[Samarth_18 · Accepted solution]

@ksmith0411 , Its returning the expected value only. Please refer the below file.

[Samarth_18]

Hi @ksmith0411 ,

Could you please share the data in raw format here not the screenshot?

It will help you get the answer more quickly. 🙂

In the meantime you could try below code:-

col =
CALCULATE (
    MIN ( 'Table'[In SVL] ),
    FILTER (
        'Table',
        'Table'[CMS skill] = EARLIER ( 'Table'[CMS skill] )
            && 'Table'[CXONE skill] = EARLIER ( 'Table'[CXONE skill] )
            && 'Table'[In SVL] > 0
    )
)