Hi Chandeep. Thanks for the tips on the DAX FILTER function, along with your bonus recommendations at the end of the video. All great advice! Thanks for sharing :)) Thumbs up!!
One modification to the explanation(Technically) is the CALCULATE function will not work on the table return by the Filter function, rather it uses the table return by the FILTER function to filter the original table and work on that. Plesae correct if this is wrong.
Hello Chandeep, this video will be very helpful to solve problem that have come across to me. Let me apprise you of situation before seeking solution, actually in the sales table column due date I presume the date by which shipment has to be made, so in some cases ship date will be before due date while in others shipment date will exactly match due date and perhaps few shipment dates will be later than due date if allowed. Actullay if I want to know SALES Amount of orders for which shipment date is exactly matches or equal to due date in ONE MEASURE without creating any helper column then how FILTER FUNCTION in combination with CALCULATE FUNCTION will be applied. Your reply will be highly commendable.
Hello, I appreciate the quality of your videos and commend you for the clarity of your explanations. I'm wondering if it's possible to apply the "Earlier" function in a DAX measure for calculating the cumulative total of revenue by product category, for instance.
Can time intelligence functions be used along with FILTER? Eg. Can I do a DISTINCTCOUNT of ID where FILTER( Value > 0 && Category = "New"), but for SAMEPERIODLASTYEAR?
One thing I did wonder, you used the measure to return a one column date table, what if you wanted a one column date table based on another column not a measure? so ; EVALUATE FILTER( ALL(Table1[Date] , Table1[Units]), Table1[Units] > 10 ) , but exclude the units from the returned table.
Hey Chandeep while using value function aren't we unknowingly eliminating few records....since value function only takes unique value of that specific column
Hey, I have a question regarding this expression: Sales >50k = Calculate( [Total Sales], FILTER( Values('Calendar'[Date]), [Total Sales]> = 50000 ))...... Is there a way to make this 50000 [Total Sales] Dynamic ? through dropdown/list filter which user can adjust?
Hey..it was really well presented. Can you explain where exactly we use Filter Function inside Calculate.. I see Logical conditions does the work instead of a Filter Function?
overall If we are using two or more table and we have to use more than one table for any dax function then is it compulsary to have relationships between all table?????? Is it already built or we have to build it ? Any one pls help me out
Hi Bro.. well explained... I have one scenario where need to compare unique values from current month to previous month data to classify in 3 types. Is that filter function will help or do I need to follow any other method. My major object is to classification of the data by comparing current month to previous month. Please advise which method will work for my scenario. Thank you for all your valuable inputs
Hi Chandeep, Do context transition happen here. FILTER(VALUES(sales[orderdate]),[total sales]>=50000). I mean the table is filtered by each date and total sales is calculated and then the condition is checked. Am i interpreting right? Would you please clarify
I am wondering what are difference of these? They have just syntax difference at First parameter of FILTER function. Would you explain both of them? First DAX Code; CALCULATE( [Total Sales], FILTER( VALUES('Calender'[Date]), [Total Sales]= 50000 ) ) Second DAX Code; CALCULATE( [Total Sales], FILTER( 'Sales', [Total Sales]= 50000 ) )
Thanks so much for making these videos, i've been trying to self learn powerbi the way you explain everything makes the most sense to me compared to every other channel. I assume it's because we've both come from an excel background. For the filter function if i wanted to use multiple filters. i.e. for year = 2012, sales > 50000, is that possible?
I have one doubt can you explain week measures like, Total Amount week to date, Total Amount for last week, Total Amount for same week last year, Period Measures Like Total amount Period to date &&& How to create Date [twomonthperiod] column date table can you please explain briefly...
Chandeep, could not understand why you would use VALUES() function on the Dates column in the Calendar table.... All dates in the Calendar table would be unique, right? 🤔🤔
Good question. The first part of the FILTER function doesn't accept a column, so I create a one columnar table using VALUES(Calendar[Date]) The above becomes a valid one columnar table. Hope this helps
Clear and well presented explanation of the Filter function. Well worth the 9 minutes of your time to learn about the filter function.
Wonderfully clear and concise video that answered all of my questions!
Hi Chandeep. Thanks for the tips on the DAX FILTER function, along with your bonus recommendations at the end of the video. All great advice! Thanks for sharing :)) Thumbs up!!
Very clear explaination...you are a good speaker
Very clear and very simple explanation. Great for beginners.
Hello chandeep ,please start series on DA-100 exam
WOW ! Learned Something new. Thanks a lot for sharing the knowledge.
Amazing oration, clear presentation, and absolutely marvelous conceptual grasp. Keep it up!
Thank you!
You are pretty good
Great. Is so easy if the logic is clear.
One modification to the explanation(Technically) is the CALCULATE function will not work on the table return by the Filter function, rather it uses the table return by the FILTER function to filter the original table and work on that. Plesae correct if this is wrong.
Thanks a lot. I have a one scenario. Need to to do running totals for count measures is it possible.
Please in a field that has true/false, how can we subtract the count of true from the count of false in power bi?
Hello Chandeep, this video will be very helpful to solve problem that have come across to me. Let me apprise you of situation before seeking solution, actually in the sales table column due date I presume the date by which shipment has to be made, so in some cases ship date will be before due date while in others shipment date will exactly match due date and perhaps few shipment dates will be later than due date if allowed. Actullay if I want to know SALES Amount of orders for which shipment date is exactly matches or equal to due date in ONE MEASURE without creating any helper column then how FILTER FUNCTION in combination with CALCULATE FUNCTION will be applied. Your reply will be highly commendable.
What do we use the syntax for between like 50000-80000 ranges ????
Hello,
I appreciate the quality of your videos and commend you for the clarity of your explanations. I'm wondering if it's possible to apply the "Earlier" function in a DAX measure for calculating the cumulative total of revenue by product category, for instance.
Great Video, helped me a lot
Can time intelligence functions be used along with FILTER? Eg. Can I do a DISTINCTCOUNT of ID where FILTER( Value > 0 && Category = "New"), but for SAMEPERIODLASTYEAR?
Hey chandeep , why don't we keep those conditions in calculate function itself? If it is so then why we need filter function as extra?
One thing I did wonder, you used the measure to return a one column date table, what if you wanted a
one column date table based on another column not a measure? so ;
EVALUATE
FILTER(
ALL(Table1[Date] , Table1[Units]), Table1[Units] > 10 ) , but exclude the units from the returned table.
Hey Chandeep while using value function aren't we unknowingly eliminating few records....since value function only takes unique value of that specific column
very informative, thank you!
Glad you like it!
Hey, I have a question regarding this expression: Sales >50k = Calculate( [Total Sales], FILTER( Values('Calendar'[Date]), [Total Sales]> = 50000 ))...... Is there a way to make this 50000 [Total Sales] Dynamic ? through dropdown/list filter which user can adjust?
Hey..it was really well presented. Can you explain where exactly we use Filter Function inside Calculate.. I see Logical conditions does the work instead of a Filter Function?
You are awesome!
Very nicely explained. Can u provide some practise workbook as well?
Could you please make a video about what are differences among “all, allexcept, allselected and removeallfilter functions in DAX
overall If we are using two or more table and we have to use more than one table for any dax function then is it compulsary to have relationships between all table?????? Is it already built or we have to build it ?
Any one pls help me out
Hi Bro.. well explained... I have one scenario where need to compare unique values from current month to previous month data to classify in 3 types. Is that filter function will help or do I need to follow any other method. My major object is to classification of the data by comparing current month to previous month.
Please advise which method will work for my scenario.
Thank you for all your valuable inputs
Hi Chandeep,
Do context transition happen here.
FILTER(VALUES(sales[orderdate]),[total sales]>=50000). I mean the table is filtered by each date and total sales is calculated and then the condition is checked. Am i interpreting right? Would you please clarify
Nice explanation
Thank you So much 🙏🏻
Hi chandeep.
I have one doubt
Difference between inside calculate & outside calculate
I am wondering what are difference of these?
They have just syntax difference at First parameter of FILTER function.
Would you explain both of them?
First DAX Code;
CALCULATE(
[Total Sales],
FILTER(
VALUES('Calender'[Date]),
[Total Sales]= 50000
)
)
Second DAX Code;
CALCULATE(
[Total Sales],
FILTER(
'Sales',
[Total Sales]= 50000
)
)
Thanks so much for making these videos, i've been trying to self learn powerbi the way you explain everything makes the most sense to me compared to every other channel. I assume it's because we've both come from an excel background.
For the filter function if i wanted to use multiple filters. i.e. for year = 2012, sales > 50000, is that possible?
Is the " Table " and the " Condition " must be from the same Table.
Hello sir please give us tutorial on data modeling part 🙏🏻🙏🏻
sir how we filter if column1 has value continuously DOWN & column2 has value Continuously UP on Same Dates.
I have one doubt can you explain week measures like, Total Amount week to date, Total Amount for last week, Total Amount for same week last year, Period Measures Like Total amount Period to date &&& How to create Date [twomonthperiod] column date table can you please explain briefly...
Thank you
Welcome Dilip!
❤️
Chandeep, could not understand why you would use VALUES() function on the Dates column in the Calendar table.... All dates in the Calendar table would be unique, right? 🤔🤔
Good question.
The first part of the FILTER function doesn't accept a column, so I create a one columnar table using VALUES(Calendar[Date])
The above becomes a valid one columnar table.
Hope this helps
please speak little slow
You have a punjabi accent dont you? 😅
You bet 😉
sir u are too fast please tell slowley