Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

ALLSELECTED() with blank

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 ...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    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] )
        )
    )
)
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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])
    )
        )
    )