Using Filter with UNION in DAX

Question

Hi,&nbsp;I am trying to flatten a table and filter by AAA values &lt;&gt; 0. So far the union works, but the filters not. How to approach this?Renewals_flat = &nbsp; &nbsp; UNION (&nbsp; &nbsp; &nbsp; &nbsp; SELECTCOLUMNS (&nbsp; &nbsp; &nbsp; &nbsp; 'Renewals',&nbsp; &nbsp; &nbsp; &nbsp; "Date", Renewals[CALENDAR_DATE],&nbsp; &nbsp; &nbsp; &nbsp; "GEO", Renewals[GEO],&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;"Type", "New_Logo",&nbsp; &nbsp; &nbsp; &nbsp; "AAA", Renewals[NEW_LOGO]&nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; SELECTCOLUMNS (&nbsp; &nbsp; &nbsp; &nbsp; 'Renewals',&nbsp; &nbsp; &nbsp; &nbsp; "Date", Renewals[CALENDAR_DATE],&nbsp; &nbsp; &nbsp; &nbsp; "GEO", Renewals[GEO],&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;"Type", "New_Expansion",&nbsp; &nbsp; &nbsp; &nbsp; "AAA", Renewals[NEW_EXPANSION]&nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; SELECTCOLUMNS (&nbsp; &nbsp; &nbsp; &nbsp; 'Renewals',&nbsp; &nbsp; &nbsp; &nbsp; "Date", Renewals[CALENDAR_DATE],&nbsp; &nbsp; &nbsp; &nbsp; "GEO", Renewals[GEO],&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;"Type", "Gross New",&nbsp; &nbsp; &nbsp; &nbsp; "AAA", Renewals[_GROSS_NEW_ALL]&nbsp; &nbsp; )&nbsp;)&nbsp;

freemanz · Accepted Answer

hi Anonymous&nbsp;how about filter the&nbsp;'Renewals'&nbsp;table first like:&nbsp;VAR _table=CALCULATETABLE(&nbsp; &nbsp; Renewals,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Renewals[NEW_LOGO]&lt;&gt;BLANK(),&nbsp; &nbsp; Renewals[NEW_EXPANSION]&lt;&gt;BLANK(),&nbsp;&nbsp;&nbsp;&nbsp;Renewals[_GROSS_NEW_ALL]&lt;&gt;BLANK(),)&nbsp;then use _table instead of Renewals in the rest of your code.

Forum Discussion

Using Filter with UNION in DAX

2 Replies

Related content

Using filter on UNION

Filter with union instead of intersection Issue

Filter data using slicer

using union in powerBI

Use ALLNOBLANKROW with UNION