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

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.