ALLSELECTED() with blank

[Anonymous]

Hello, I managed to solve a problem using the ALLSELECTED() function, but now the array has a lot of blank lines, how can I remove it?

By the filters I can't, since if I filter a column it excludes the value of the others.

Fluxo =

CALCULATE(

    [Total Fluxo] + [Total Saldo Bancário],

    FILTER(

        ALLSELECTED('D-Pagar + Receber'),

        'D-Pagar + Receber'[Data] <= MAX('BA-Data'[Data_Base])

    )

)

[Jihwan_Kim · Accepted solution]

Hi,

Could you please try the below whether it suits your requirement?

Fluxo =
IF (
    [Total a receber measure] <> BLANK ()
        && [Tltal a pagar measure] <> BLANK (),
    CALCULATE (
        [Total Fluxo] + [Total Saldo Bancário],
        FILTER (
            ALLSELECTED ( 'D-Pagar + Receber' ),
            'D-Pagar + Receber'[Data] <= MAX ( 'BA-Data'[Data_Base] )
        )
    )
)

[Anonymous]

Thanks for your @Jihwan_Kim solution.

I just needed to change the "&&" operator to "||" and it worked perfectly.

Thanks a lot for the solution.

Fluxo =

IF (

    [Total a Pagar] <> BLANK ()

    || [Total a Receber] <> BLANK (),

CALCULATE(

        [Total Fluxo] + [Total Saldo Bancário],

                FILTER(

                ALLSELECTED('D-Pagar + Receber'),

                'D-Pagar + Receber'[Data] <= MAX('BA-Data'[Data_Base])

)

    )

)

[Anonymous]

Hi, @Shaurya 

These blank values are traditional when I use ALLSELECTED(), the filter needs to be applied within the measure itself to work. I've tried to use all the filters, I only have the measure, but I'm not getting it.

[Shaurya]

Hi @Anonymous,

Why don't you try using the filters? Select all values first and just uncheck Blank.

Works for you? Mark this post as a solution if it does!