DAX Fridays! #87: DISTINCT vs DISTINCTCOUNT vs VALUES

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 ธ.ค. 2024

ความคิดเห็น •

  • @williamarthur4801
    @williamarthur4801 2 ปีที่แล้ว

    Thanks for that, and thank you for giving the link to the Marco Russo blog.

  • @kevinlabore1726
    @kevinlabore1726 6 ปีที่แล้ว +2

    I think this is a good example of how there are often more than one way to arrive at the same result -- what might be confusing (at least for us less experienced users) if there are advantages to using one over an other.... either in readability and/or performance.

    • @CurbalEN
      @CurbalEN  6 ปีที่แล้ว +2

      I agree Kevin! when I was a newbie , if performance was not an issue, I spent all my energy to get the right result and tried to learn why some things didn’t work.
      Readability can be done using comments even as a beginner to aid others.
      When it comes to performance... well, that takes time.
      /Ruth

    • @kevinlabore1726
      @kevinlabore1726 6 ปีที่แล้ว +1

      There is a video I saw ( I believe by the Power BI Team) -- that demonstrates how you can DaxStudio to evaluate Dax Expressions/Formula and time server took to execute etc now that I think about it.... I have only barely tried DaxStudio.

    • @CurbalEN
      @CurbalEN  6 ปีที่แล้ว

      That is a great resource, :)
      /Ruth

  • @ThalassaMavri
    @ThalassaMavri 6 ปีที่แล้ว +1

    Thank you for the video Ruth, have a great vacation time!

    • @CurbalEN
      @CurbalEN  6 ปีที่แล้ว +1

      Hi Alina! Thanks and same to you when it is time :)
      /Ruth

  • @brunof.s.8186
    @brunof.s.8186 6 ปีที่แล้ว +1

    Your videos are awesome. Cheers from Brazil

    • @CurbalEN
      @CurbalEN  6 ปีที่แล้ว

      Obrigado!! :)
      /Ruth

  • @mehdihammadi6145
    @mehdihammadi6145 6 ปีที่แล้ว +1

    Tahnk for sharing Ruth and good holidays

    • @CurbalEN
      @CurbalEN  6 ปีที่แล้ว

      Same to you when they start!!
      /Rutg

  • @giovani6666
    @giovani6666 6 ปีที่แล้ว +1

    Glad you're back!
    Thanks for the content, Ruth.

    • @CurbalEN
      @CurbalEN  6 ปีที่แล้ว

      You welcome!! Glad that it is useful :)
      /Ruth

  • @Victor-ol1lo
    @Victor-ol1lo 6 ปีที่แล้ว +1

    Nice video !!! Enjoy your vacation and relax a little ...

    • @CurbalEN
      @CurbalEN  6 ปีที่แล้ว

      😂😂 I will try :)
      /Ruth

  • @thomlinford
    @thomlinford 6 ปีที่แล้ว +4

    Thanks for the video Ruth - just a heads up there might be issue with the volume in first part of the video. It's much softer that the computer presentation.

    • @CurbalEN
      @CurbalEN  6 ปีที่แล้ว

      Oh thanks! My normal microphone run out of batteries so I used another one... hope it is audible anyway 😳
      /Ruth

    • @thomlinford
      @thomlinford 6 ปีที่แล้ว +1

      Curbal still audible for sure :)

    • @CurbalEN
      @CurbalEN  6 ปีที่แล้ว

      Ufff... that is great! And thanks for letting me know!
      Happy Friday :)
      /Ruth

  • @BertandRussell
    @BertandRussell 6 ปีที่แล้ว +1

    Hi Ruth,
    Hope you are doing good. If you allow me, then I ask you a query. Can we see part calculation of Formula in Power BI, likewise we do in MS Excel, by pressing F9.
    Thanks and warm regards.

    • @CurbalEN
      @CurbalEN  6 ปีที่แล้ว

      Not that I am aware of but ask in the power bi community in case someone knows!
      /Ruth

    • @SyedUsman
      @SyedUsman 6 ปีที่แล้ว +1

      Did you get your answer?

    • @CurbalEN
      @CurbalEN  6 ปีที่แล้ว

      You best bet is to ask the power bi community, I still don’t know..
      /Ruth

  • @SyedUsman
    @SyedUsman 6 ปีที่แล้ว +1

    Love this channel !

    • @CurbalEN
      @CurbalEN  6 ปีที่แล้ว

      Thanks Syed :)
      /Ruth

  • @krisvannieuwenhove2297
    @krisvannieuwenhove2297 5 ปีที่แล้ว

    Hi Ruth, I'm brand new in DAX and Power BI. I understand that Distinct creates a column of distinct values. How can I make these values on itself visible. I'm not interested in the sum or count or whatever of the values in a column, I want the values on itself. I was wondering if this is possible? Kind regards, Kris

  • @excelparatodos2562
    @excelparatodos2562 3 ปีที่แล้ว

    I'm Brazilian and I really like your posts.
    Can I sum values distinct???

  • @dexterpayoyo5912
    @dexterpayoyo5912 4 ปีที่แล้ว

    Hi. How to do a cumulative distinctcount in a monthly basis? For example month of March, the distinctcount will be from Jan-March and for month of April (Jan-April) and so on.. Appreciate you feedback please.

  • @avulasandeep
    @avulasandeep 6 ปีที่แล้ว +1

    Can you please make a video on the Relationship of Cardinality and cross filter of single and both Direction

    • @CurbalEN
      @CurbalEN  6 ปีที่แล้ว

      Hi Sandeep,
      Have you seen this?
      m.th-cam.com/video/-4ybWQSRcOY/w-d-xo.html

    • @avulasandeep
      @avulasandeep 6 ปีที่แล้ว +1

      i missed this video i think. Thanks for sharing

  • @dheenapriya6181
    @dheenapriya6181 4 ปีที่แล้ว

    how to count a measure.. like measure named 'status' then i want count(status=orange)>1 then "not urgent"... how to do this?? in powerbi i cant able to count measure

  • @sudherkumar4292
    @sudherkumar4292 5 ปีที่แล้ว

    Is there any way to create unique list from two tables without powequrey.can we get the result by using dax code????

    • @CurbalEN
      @CurbalEN  5 ปีที่แล้ว

      Check the videos here to see what you need:
      curbal.com/blog/joining-table-in-power-bi-with-power-query-and-dax
      /Ruth

    • @sudherkumar4292
      @sudherkumar4292 5 ปีที่แล้ว

      @@CurbalEN I want this result without powequrey ... only by dax
      Table 1
      Product Nos
      A 1
      B 2
      C 1
      F 14
      R 1
      Table 2
      Product Nos
      A 10
      B 12
      C 6
      F 4
      D 2
      H 1
      G 255
      (Output Table) Master List
      A
      B
      C
      F
      R
      D
      H
      G

    • @CurbalEN
      @CurbalEN  5 ปีที่แล้ว

      The DAX videos are at the end of the blog post.
      /Ruth

    • @akshayachandrasekar8285
      @akshayachandrasekar8285 2 ปีที่แล้ว

      @@sudherkumar4292 are the letter names in a different column or is it like A1 together?

  • @jasonwoodward5501
    @jasonwoodward5501 6 ปีที่แล้ว

    Ruth, this is good. Thanks

    • @CurbalEN
      @CurbalEN  6 ปีที่แล้ว

      My pleasure 😇
      /Ruth

  • @jaimeildefonsosegurapena7328
    @jaimeildefonsosegurapena7328 4 ปีที่แล้ว

    I had an interesting case:
    Had a star schema, no Order and OrderDetails... just OrderDetails (on my model called VENTAS) son OrderID (called Facturas had duplicates)
    On the Clients Table, I wanted to add a calculated column to know number of different Invoices.
    I used:
    =COUNTROWS(DISTINCT(SELECTCOLUMNS( RELATEDTABLE(VENTAS) , "Documento", VENTAS[Factura])))
    and worked fine!
    I tried (thinking the sugar syntax will simplify):
    =DISTINCTCOUNT(SELECTCOLUMNS( RELATEDTABLE(VENTAS) , "Documento", VENTAS[Factura]))
    and just got errors...
    I gave up, return to the original formula and tried a little (unrisky I thought) change:
    =COUNTROWS(VALUES(SELECTCOLUMNS( RELATEDTABLE(VENTAS) , "Documento", VENTAS[Factura])))
    and the same... just errors
    Not sure what are the differences (on semantics?) of these functions when used on Row Context...

  • @Hustling_Learning
    @Hustling_Learning 3 ปีที่แล้ว

    What will happen if we use distinct, distinctcount and values to a single table without having relationship with another table.

  • @stevennye5075
    @stevennye5075 5 ปีที่แล้ว

    very good explanation

    • @CurbalEN
      @CurbalEN  5 ปีที่แล้ว

      Thanks Steve!
      /Ruth

  • @negisaab74347
    @negisaab74347 3 ปีที่แล้ว

    Distict count gives you scalar value of unique items wherein distinct value given you table of unique items...