DAX FILTER Function

Поделиться
HTML-код
  • Опубликовано: 10 дек 2024

Комментарии • 50

  • @CJ-jc8tn
    @CJ-jc8tn 3 года назад +4

    Clear and well presented explanation of the Filter function. Well worth the 9 minutes of your time to learn about the filter function.

  • @tracy2919
    @tracy2919 10 месяцев назад

    Wonderfully clear and concise video that answered all of my questions!

  • @wayneedmondson1065
    @wayneedmondson1065 3 года назад +1

    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!!

  • @shikharbhardwaj1352
    @shikharbhardwaj1352 Год назад

    Very clear explaination...you are a good speaker

  • @penglai3668
    @penglai3668 3 года назад

    Very clear and very simple explanation. Great for beginners.

  • @Laxmanmane007
    @Laxmanmane007 3 года назад +3

    Hello chandeep ,please start series on DA-100 exam

  • @cblondhe
    @cblondhe 3 года назад

    WOW ! Learned Something new. Thanks a lot for sharing the knowledge.

  • @hamzasaqib511
    @hamzasaqib511 2 года назад

    Amazing oration, clear presentation, and absolutely marvelous conceptual grasp. Keep it up!

  • @bujorsergiu9342
    @bujorsergiu9342 8 месяцев назад

    Great. Is so easy if the logic is clear.

  • @KgasS
    @KgasS 2 года назад

    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.

  • @SURESHK-hq3wf
    @SURESHK-hq3wf 2 года назад

    Thanks a lot. I have a one scenario. Need to to do running totals for count measures is it possible.

  • @christinemak7120
    @christinemak7120 4 месяца назад

    Please in a field that has true/false, how can we subtract the count of true from the count of false in power bi?

  • @aftabahmed86
    @aftabahmed86 Год назад

    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.

  • @snehadeekshitha5139
    @snehadeekshitha5139 3 года назад

    What do we use the syntax for between like 50000-80000 ranges ????

  • @jaimansourimohammedamine5395
    @jaimansourimohammedamine5395 10 месяцев назад

    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.

  • @ohmandy09
    @ohmandy09 2 года назад

    Great Video, helped me a lot

  • @arnabmit
    @arnabmit 2 года назад

    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?

  • @bharathreddy4267
    @bharathreddy4267 Год назад

    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?

  • @williamarthur4801
    @williamarthur4801 Год назад

    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.

  • @vashisht1
    @vashisht1 2 года назад

    Hey Chandeep while using value function aren't we unknowingly eliminating few records....since value function only takes unique value of that specific column

  • @gervith103
    @gervith103 2 года назад

    very informative, thank you!

  • @saqeefavorites
    @saqeefavorites 4 месяца назад

    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?

  • @DineshKumar-xl2ug
    @DineshKumar-xl2ug 2 года назад

    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?

  • @TheBirdChannelOriginal
    @TheBirdChannelOriginal 3 года назад

    You are awesome!

  • @sass520
    @sass520 2 года назад

    Very nicely explained. Can u provide some practise workbook as well?

  • @rashidkhan8161
    @rashidkhan8161 2 года назад

    Could you please make a video about what are differences among “all, allexcept, allselected and removeallfilter functions in DAX

  • @shubhamyadav-ig8bi
    @shubhamyadav-ig8bi Год назад

    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

  • @DineshP-v4y
    @DineshP-v4y Год назад

    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

  • @sriharshagottipati4760
    @sriharshagottipati4760 3 года назад

    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

  • @sravankumar1767
    @sravankumar1767 3 года назад

    Nice explanation

  • @nikhilpatil4877
    @nikhilpatil4877 3 месяца назад

    Thank you So much 🙏🏻

  • @pavankumarreddy189
    @pavankumarreddy189 3 года назад

    Hi chandeep.
    I have one doubt
    Difference between inside calculate & outside calculate

  • @cuneytklc8501
    @cuneytklc8501 3 года назад

    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
    )
    )

  • @jayxpea
    @jayxpea 3 года назад

    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?

  • @venkatareddykummitha5863
    @venkatareddykummitha5863 2 года назад

    Is the " Table " and the " Condition " must be from the same Table.

  • @gunjankanani8039
    @gunjankanani8039 2 года назад

    Hello sir please give us tutorial on data modeling part 🙏🏻🙏🏻

  • @designmain4722
    @designmain4722 3 года назад

    sir how we filter if column1 has value continuously DOWN & column2 has value Continuously UP on Same Dates.

  • @sravankumar1767
    @sravankumar1767 3 года назад

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

  • @Dilipkr-jk9oh
    @Dilipkr-jk9oh Год назад

    Thank you

  • @krantikumar894
    @krantikumar894 3 года назад

    ❤️

  • @ajieapen
    @ajieapen 3 года назад +1

    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? 🤔🤔

    • @GoodlyChandeep
      @GoodlyChandeep  3 года назад +2

      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

  • @monikamanchanda1626
    @monikamanchanda1626 Год назад +1

    please speak little slow

  • @simranjitkaur6388
    @simranjitkaur6388 11 месяцев назад +1

    You have a punjabi accent dont you? 😅

  • @yashgarg4937
    @yashgarg4937 Год назад

    sir u are too fast please tell slowley