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.
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
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.
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.
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.
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
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.
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
@@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
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...
Thanks for that, and thank you for giving the link to the Marco Russo blog.
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.
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
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.
That is a great resource, :)
/Ruth
Thank you for the video Ruth, have a great vacation time!
Hi Alina! Thanks and same to you when it is time :)
/Ruth
Your videos are awesome. Cheers from Brazil
Obrigado!! :)
/Ruth
Tahnk for sharing Ruth and good holidays
Same to you when they start!!
/Rutg
Glad you're back!
Thanks for the content, Ruth.
You welcome!! Glad that it is useful :)
/Ruth
Nice video !!! Enjoy your vacation and relax a little ...
😂😂 I will try :)
/Ruth
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.
Oh thanks! My normal microphone run out of batteries so I used another one... hope it is audible anyway 😳
/Ruth
Curbal still audible for sure :)
Ufff... that is great! And thanks for letting me know!
Happy Friday :)
/Ruth
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.
Not that I am aware of but ask in the power bi community in case someone knows!
/Ruth
Did you get your answer?
You best bet is to ask the power bi community, I still don’t know..
/Ruth
Love this channel !
Thanks Syed :)
/Ruth
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
I'm Brazilian and I really like your posts.
Can I sum values distinct???
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.
Can you please make a video on the Relationship of Cardinality and cross filter of single and both Direction
Hi Sandeep,
Have you seen this?
m.th-cam.com/video/-4ybWQSRcOY/w-d-xo.html
i missed this video i think. Thanks for sharing
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
Is there any way to create unique list from two tables without powequrey.can we get the result by using dax code????
Check the videos here to see what you need:
curbal.com/blog/joining-table-in-power-bi-with-power-query-and-dax
/Ruth
@@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
The DAX videos are at the end of the blog post.
/Ruth
@@sudherkumar4292 are the letter names in a different column or is it like A1 together?
Ruth, this is good. Thanks
My pleasure 😇
/Ruth
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...
What will happen if we use distinct, distinctcount and values to a single table without having relationship with another table.
very good explanation
Thanks Steve!
/Ruth
Distict count gives you scalar value of unique items wherein distinct value given you table of unique items...