Forum Discussion
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
- MFelixSuper User
Hi Poisedon,
Can you please post some data or a sample of the file you are using?
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of @Greg_Deckler).Regards,
MFelix
- v-jiascu-msftMicrosoft Employee