Forum Discussion

danish169's avatar
danish169
Icon for Helper I rankHelper I
4 years ago
Solved

Firstnonblank and a filtered table

Hi, tried many variations of the following dax expression. Sometimes I get an error, other times a blank and then the error about cannot find a scalar value. I have experimented with min too.    Th...
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI danish169,

    Here is the formula that I modify based on the expressions that you share, you can try it if the performance improved:

    Added Wishlist By Admin =
VAR filtered =
    FILTER (
        'temp wishlist_stock_alert',
        [created_at] <= 'temp call_suite_list_calls_by_extension'[DateFinish]
            && [created_at] >= 'temp call_suite_list_calls_by_extension'[DateStart]
            && [created_by] = 'temp call_suite_list_calls_by_extension'[UserID]
    )
VAR _id =
    MINX ( filtered, [id] )
RETURN
    IF (
        'temp call_suite_list_calls_by_extension'[UserID] <> BLANK (),
        MINX ( FILTER ( filtered, [id] = _id ), [created_by] )
    )

    Regards,

    Xiaoxin Sheng

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

danish169 , This is a new calculated column, this will not take slicer value

 

Try like
Added Wishlist By Admin =

var datetimestart = date(2022,02,22) + time(15,48,00)
var timefinish = date(2022,02,22) + time (16,03,00)

return

calculate(FIRSTNONBLANK('temp wishlist_stock_alert'[created_by],1),
filter('temp wishlist_stock_alert','temp wishlist_stock_alert'[created_at] <= timefinish && 'temp wishlist_stock_alert'[created_at] >= datetimestart && not(Isblank('temp wishlist_stock_alert'[created_by] ))))

 

 

danish169's avatar
danish169
Icon for Helper I rankHelper I
4 years ago

Ok cool, a calculated column would work best. Just tried your code and got the followign error:

 

Now ive seen this before with "not(isblank(.....)" which is why i used "<> BLANK()" in my original code to avoid it. 

Feels super close yet so far haha