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

4 Replies

  • 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!

  • 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.

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