Forum Discussion
Slicer for two queries
I think I know why. I have transaction ids which are supposed to be unique, but a few are just zero.
How can I fix this? I'm importing the numbers from Google Analytics.
So if I understand your post; you are importing data that has a conflict flaw in the ID field of multiple 0s.
Call the imported table 1. You would want to create a 'Table 1 Clean'.
In the data view on the left frame, and in the Modeling tab in the ribbon you select the New Table option which will offer you then an expression field just below the ribbon. Here is where you would define your new table:
Table 1 Clean = FILTER(Table1,Table1[ID]>0)
press enter and it gets created. Everytime you refresh your data source this will fire.
Would that filter out transactions that are tied to the invalid ID?
in Table 1 Clean there would be no record where the ID = 0
in another table - let's say Table 2 - that record is still there - but of course it has nothing to join to in Table 1 Clean so it would depend on your method of looking at the data. It is still seen unless your expression is to only show data that matches Table 1 Clean.
