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] )
        )
    )
)
Shaurya's avatar
Shaurya
Icon for Memorable Member rankMemorable Member
4 years ago

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!