Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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".
Hi @Poisedon,
Troubleshooting needs the original data. Please share a dummy sample.
Best Regards,
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsJoin the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.