How to Use the Filter DAX Function in Power BI [The Basics]

How to Use the Filter DAX Function in Power BI [The Basics]/ In this tutorial, we will learn the basics of the FILTER DAX function in Power BI. The FILTER DAX function is a table function that instead of returning a single value returns a table.

Navigate through the content below:
0:33 Content
1:07 Filter explained
1:45 Syntax
2:34 Main uses
3:42 Practical cases

Please follow us on:

Leave your comments and questions below!
Don't forget to subscribe!
Thanks so much!

#DAX #PowerBIDAX #Filter #vizxlization

[xeeshanahmad]

Brilliantly explained, Filter . Clears my Logic about filter and Nested Filters. Thanks

[leticiacardoso]

Thank you!! I am an intern for a company and have been challenged to build some power b.i reports! Your videos are helping a lot!

[Kingsley]

This is the best explanation for filter function, thank you!

[mqurram]

Thank you very much Sir, I’m becoming pro now after watching this video .

[TheSourav]

Very nice explanation! Having a hard time to understand DAX but your explanation with scenario made thing more understandable.

You got a subs

[Deeps]

That's called teaching Amazingly taught 👌

[eduardomunoz]

Como siempre, excelente explicación. Saludos y un abrazo Néstor.

[sravankumar]

Amazing bro, do more videos Time intelligence and information function, i am enjoying a lot

[shafeeqniyas]

Great explanation thank you very much for this session

[granand]

Why youtube is removing my comment. Hey Bro Nestor, thanks a ton. Most practical and with learners in mind video. It really helped.

[revorg]

Esta explicación quedó más clara, la duda es que se elabora una nueva tabla, definida con variables, para utilizarla en esa solución, puede ser multiple, utilizando un SWITCH??? Muy buena introducción del tema, obliga a pensar y tener en cuenta esa solución... Felicitaciones mi pana!!!!

«Compartir el conocimiento es una acción de seres inteligentes que han comprobado que el conocimiento es un bien que crece a medida que se comparte»

[raghun]

In this tutorial, for TV only u used the formula TV= Filter(Claims, ....)...but in theory you said we cannot use filter() independently?

[naXnappy]

Hi thanks !
Is it possible to use it as a key measure? what funtion do i need to use then?

I have the problem that i have an article list with featues of the article and each feature is listed row by row, so the same article number is listed many times by the times features you have.

I dont wanna creat a table for each feature because i have like 20 needed features.

Looking forward to your reponse.

[noelngc]

Thank You. Is there any difference in performance between the nested FILTER() functions and CALCULATETABLE() - Printer Phoenix = CALCULATETABLE(Claims, Claims[Product Claimed] = "Printer", Claims[City] = "Phoenix")

[paramjeetsingh]

Brother should I do excel or power bi?

[granand]

Is there a way to get the tables we have added via DAX, in modelling in "Data view" into "Query Editor"

[vinod]

Sir how we filter a stock price value increase contineously since 3days,

I mean to say the value which varies with date how to filter it.

Please help

[chimamakaanakwuo-nwosu]

Good afternoon Nestor, Thank you so much for the video.
When i tried solving the third question (Count of printer), after creating the measure, i tried visualizing it, it brought out a blank page. please how do i resolve this?

[monmorelord]

Hello

A few things
1. In relation to your nested Filter functions why did you not use One Fiilter function and BOOLEAN EXPRESION like AND
2. I draw your attention to Microsofts page "Avoid using FILTER as a filter argument" that is is as confucing as hell and seems to contratict itself
3. One the reasosns DAX is so hard to learn is the documentation is piss poo and another is there are senseless contractictions plus there are peopel on Youtube providing explanation without understanding the full explanations thmeselves...thus providing confusion

I think your explantion is fine but you need to look at optimisating your measures in another video

[irfanabbassi]

Why not only use

Filter (claims,
claims [products claimed]= " printer" && claims[city] = "phoneix" )