Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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êsShare feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 53 | |
| 49 | |
| 33 | |
| 16 | |
| 15 |
| User | Count |
|---|---|
| 85 | |
| 70 | |
| 38 | |
| 28 | |
| 25 |