Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Using Filter with UNION in DAX

Hi,   I am trying to flatten a table and filter by AAA values <> 0. So far the union works, but the filters not. How to approach this? Renewals_flat =     UNION (         SELECTCOLUMNS...
Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Anonymous 

    how about filter the 'Renewals' table first like:
     
    VAR _table=
    CALCULATETABLE(
        Renewals, 
        Renewals[NEW_LOGO]<>BLANK(),
        Renewals[NEW_EXPANSION]<>BLANK(),
        Renewals[_GROSS_NEW_ALL]<>BLANK(),
    )
     
    then use _table instead of Renewals in the rest of your code.
FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi Anonymous 

how about filter the 'Renewals' table first like:
 
VAR _table=
CALCULATETABLE(
    Renewals, 
    Renewals[NEW_LOGO]<>BLANK(),
    Renewals[NEW_EXPANSION]<>BLANK(),
    Renewals[_GROSS_NEW_ALL]<>BLANK(),
)
 
then use _table instead of Renewals in the rest of your code.