DAX Fridays! #87: DISTINCT vs DISTINCTCOUNT vs VALUES

[@williamarthur4801]

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

[@kevinlabore1726]

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]

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]

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]

That is a great resource, :) /Ruth

[@ThalassaMavri]

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

[@CurbalEN]

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

[@Victor-ol1lo]

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

[@CurbalEN]

😂😂 I will try :) /Ruth

[@giovani6666]

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

[@CurbalEN]

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

[@brunof.s.8186]

Your videos are awesome. Cheers from Brazil

[@CurbalEN]

Obrigado!! :) /Ruth

[@mehdihammadi6145]

Tahnk for sharing Ruth and good holidays

[@CurbalEN]

Same to you when they start!! /Rutg

[@thomlinford]

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]

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

[@thomlinford]

Curbal still audible for sure :)

[@CurbalEN]

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

[@excelparatodos2562]

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

[@dexterpayoyo5912]

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.

[@SyedUsman]

Love this channel !

[@CurbalEN]

Thanks Syed :) /Ruth

[@jaimeildefonsosegurapena7328]

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

[@krisvannieuwenhove2297]

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

[@dheenapriya6181]

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

[@BertandRussell]

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]

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

[@SyedUsman]

Did you get your answer?

[@CurbalEN]

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

[@stevennye5075]

very good explanation

[@CurbalEN]

Thanks Steve! /Ruth

[@avulasandeep]

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

[@CurbalEN]

Hi Sandeep, Have you seen this? m.kzbin.info/www/bejne/Y2Xck4qHiLeWhbs

[@avulasandeep]

i missed this video i think. Thanks for sharing

[@jasonwoodward5501]

Ruth, this is good. Thanks

[@CurbalEN]

My pleasure 😇 /Ruth

[@Hustling_Learning]

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

[@negisaab74347]

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

[@sudherkumar4292]

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

[@CurbalEN]

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

[@sudherkumar4292]

@@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]

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

[@akshayachandrasekar8285]

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