Power BI DAX for Beginners: COUNT, COUNTA, COUNTX, COUNTAX, COUNTBLANK, DISTICTCOUNT, COUNTROWS

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

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

  • @tonysingh5207
    @tonysingh5207 2 года назад +1

    I am ever so grateful for your input and they way you communicate your message in an understandable way, Would you be able to assist with a 14 day moving average expression, with thanks & regards.

  • @ypng9040
    @ypng9040 Месяц назад

    Can't thank you enough for this clear and concise breakdown!
    Watching the ads as my way of saying thanks =D

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

    Thanks for the simplest explanation. very easy to understand

  • @shajahan-cp3fu
    @shajahan-cp3fu Год назад +1

    Thank you for your explanation. 😇

  • @TinZar-z6j
    @TinZar-z6j 2 месяца назад

    Thank you so much for your explanations and efforts. It is very clear and understandable.

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

    gracias,, excelente, saludos desde Colombia

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

    Thanks bro from this I have learnt the complication things very easily the way of your explanation and presentation is much effective for the learners thanks once again.

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

    The way of teaching and indepth knowledge about DAX is really fabulous. I am so greatful and thankful for your wonderful DAX sessions .💐🤝♥️♥️Really loved it.

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

    Thank you vary much to your Awesome tuts.

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

    Another great one boss.

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

    I have one request which will be very helpful, learning this way will just help us to get the intro about different dax function but if we don't, apply them in real life scenario then no one will be able to solve complex queries, please make a video on writing queries, like we have a table and we need another table as an output by dax, it will help us to apply the function and write complex queries

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

    can you provide more examples with countx with filter

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

    Please do vedios on product and productx in aggregate dax function in power bi

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

    Finished watching

  • @mr.prasadyadav
    @mr.prasadyadav 2 года назад

    Clear Explanation , Thank you Sir

  • @cilumpallimythili6140
    @cilumpallimythili6140 2 года назад +1

    good explanation , thank you

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

    I have subscribed your channel for more information and updates 💐♥️

  • @skawflat1115
    @skawflat1115 2 месяца назад

    Thanks very helpful

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

    Thank you ♥️🙏

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

    Thank you..can you share video for allexcept function in dax

  • @PowerInsights-i2x
    @PowerInsights-i2x 8 месяцев назад

    Thanks for the video. helpful

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

    Excellent explanations! I'd like to know how to use the functions, particularly using CountX and CountAX to count "text" values (non Boolean) rather than numerical.
    I have a table with vendors/suppliers that deliver different parts. Some of the vendors deliver some of the same parts, so two vendors may have the same Part No..
    Parts per vendor are marked as delivered Early, On-time, and Late. I want to count each of these three delivery statuses per part and vendor to then calculate the percentage of each delivery status per vendor out of the Grand Total of all deliveries and the percentage based on each delivery type/status. For now, this is the formula I came up with to count early deliveries:
    _CountX = COUNTAX(FILTER(Delivery, Delivery[Delivery Type] = Early()), Delivery[Delivery Type])
    Thanks for your help!

  • @saikumarp-s2t
    @saikumarp-s2t Год назад

    why can't we distinct count filter apply to the filter section in which I get a distinct count for the category

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

    Yaar apki strategy bohot acchi he, well explain bhi karte ho but yaar aap at least 50 most important formulas explain kar do plz

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

    So nice sir, great explaination 🙏🙏🙏

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

    Thank you....

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

    count function supports Boolean values also I am checking Microsoft official document

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

    What a great video, really enjoyed it.

  • @chandrakumarv9304
    @chandrakumarv9304 2 года назад +1

    Wonderfull bro, SSL(Subscribed,Shared and LIKED ) Done :)

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

    Best explanation

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

    Nice informative video 👍👍👍

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

    Please explain "CALCULATE" dax function

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

    I am working on IPL data sets one column consist runs bats scored every ball i.e 0 1 2 3 4 6 and another column strike batsman how to calculate how many 4s scored a single batsman. In column I have to count the distinct value equal to 4 in then it also need to count by the batsman becoz in this batsman name also repeated

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

    Nice

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

    Send link entire dax functions

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

      Work IN Progress!! More Videos come during next 30 Days. Still few are available
      ruclips.net/p/PLib8Q64STW-uiLY00WeYHfLkQbR3G4Ydd

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

    pls provide average dax command practice file

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

    Resource file plz

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

      github.com/Dhruvinshah16/Power-BI/tree/master/Power%20BI%20-DAX/COUNT

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

      Thank you ji

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

    Summarize function

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

    Please send data

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

      github.com/Dhruvinshah16/Power-BI/tree/master/Power%20BI%20-DAX/COUNT

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

      This is more useful to me thank you sir ❤