Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Poisedon
Frequent Visitor

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".

 

Immagine.jpg

 

 

 

2 REPLIES 2
v-jiascu-msft
Employee
Employee

Hi @Poisedon,

 

Troubleshooting needs the original data. Please share a dummy sample. 

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MFelix
Super User
Super 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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.