How to exclude NAN in my measure

[SelflearningBi]

Please see my fuction, There are NAN is shipped different, I would like to set NAN as empty as well , somehow this function displays NAN as No. 
I just want , NAN in the IN FULL column should show nothing,  blank()

please help ~

[v-yalanwu-msft · Accepted solution]

Hi, @SelflearningBi ;

Try it.

In Full =
IF (
    'FW22_5 25'[Shipped Qty Difference] = "NaN",
    BLANK (),
    IF (
        AND (
            'FW22_5 25'[Shipped Qty Difference] >= 0,
            'FW22_5 25'[Shipped Qty Difference] <= 0.02
        ),
        "Yes",
        "No"
    )
)

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @SelflearningBi 

Check If this measure can solve the issue

In Full =
VAR EXCLUSENAN =
CALCULATE (
SUM ( 'FW22_5 25'[Shipped Qty Difference] ),
FILTER (
'FW22_525',
'FW22_5 25'[Shipped Qty Difference]
<> (
0
/ BLANK ()
)
)
)
RETURN
IF (
'FW22_5 25'[Shipped Qty Difference] = "NaN",
"Nan",
IF (
AND (
'FW22_5 25'[Shipped Qty Difference] >= 0,
'FW22_5 25'[Shipped Qty Difference] <= 0.02
),
"Yes",
"No"
)
)

If this post helps, accept it as a solution