Solved: CSV file downloading blank when based on a slice - Page 2

Phil_Waite · 02-24-2020 07:50 AM

I have slice of a main table that is created using a user defined table so they csan search for different type of outlets int he data. It always downloads a blank csv file though with just column headings.

(I posted this previously and Steve asked me to post a screen shot of my table but I can’t find that original post)

So here it is. thanks Phil

Phil_Waite

The following seems to work:

I have created 4 new virtual columns (with temp names for the mo) and given each the following app formula

SELECT( Filterlist[Outlet Rating], [User Id] =USEREMAIL() )
SELECT( Filterlist[Price Band Name], [User Id] =USEREMAIL() )
SELECT( Filterlist[Postcode (letters)], [User Id] =USEREMAIL() )
SELECT( Filterlist[Outlet Type], [User Id] =USEREMAIL() )

I then changed the slice formula to the following

AND(
IN( [Outlet Rating], [New Virtual Column] ),
IN( [Price List], [New Virtual Column 1] ),
IN( [Spare], [New Virtual Column 2] ),
IN( [Outlet Type], [New Virtual Column 3] ))

The expression has been broken up using virtual columns which seems to have solved it.

Thanks

Phil

View solution in original post