Forum Discussion

Poisedon's avatar
Poisedon
Frequent Visitor
7 years ago

Apply a filter change data in table

I've this problem, I think is easy for you guys. I need to filter my data when column "Fatturato medio ultimi 2 mesi" is bigger than "Fatturato medio mensile" so I created a data filter (see formula in picture).
Problem is when i check "true", it change values, i think because it take only files where is true that condition (my query take data from many files, where "Cliente" may be the same for 2 or more files). How can I filter taking all files so without change data in my table? In my case "Burger King" must be false not true so it is wrong.
Other formulas:
Fatturato medio mensile = INT('Fatture'[Fatturato totale]/12)
Fatturato medio ultimi 2 mesi = ('Fatture'[Fatturato penultimo mese]+'Fatture'[Fatturato ultimo mese])/2
Totale fatture is number of files of that "Cliente".

 

 

 

 

2 Replies