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

  Рет қаралды 31,564

Dhruvin Shah

Dhruvin Shah

Күн бұрын

Пікірлер: 45
@angelclarke1942
@angelclarke1942 7 ай бұрын
can you provide more examples with countx with filter
@shankar565627
@shankar565627 7 ай бұрын
count function supports Boolean values also I am checking Microsoft official document
@saikumarp-s2t
@saikumarp-s2t 11 ай бұрын
why can't we distinct count filter apply to the filter section in which I get a distinct count for the category
@chandrakumarv9304
@chandrakumarv9304 2 жыл бұрын
Wonderfull bro, SSL(Subscribed,Shared and LIKED ) Done :)
@bidhanry9740
@bidhanry9740 Жыл бұрын
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
@ypng9040
@ypng9040 Ай бұрын
Can't thank you enough for this clear and concise breakdown! Watching the ads as my way of saying thanks =D
@tonysingh5207
@tonysingh5207 Жыл бұрын
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.
@josephabuo6027
@josephabuo6027 3 жыл бұрын
Another great one boss.
@shajahan-cp3fu
@shajahan-cp3fu Жыл бұрын
Thank you for your explanation. 😇
@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
@cilumpallimythili6140
@cilumpallimythili6140 2 жыл бұрын
good explanation , thank you
@TinZar-z6j
@TinZar-z6j 2 ай бұрын
Thank you so much for your explanations and efforts. It is very clear and understandable.
@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!
@kenchappahalamani319
@kenchappahalamani319 2 жыл бұрын
I have subscribed your channel for more information and updates 💐♥️
@parvejmahmud1740
@parvejmahmud1740 Жыл бұрын
Please explain "CALCULATE" dax function
@poornimaramachandran5338
@poornimaramachandran5338 Жыл бұрын
Please do vedios on product and productx in aggregate dax function in power bi
@arunhariharan2867
@arunhariharan2867 2 жыл бұрын
Thank you..can you share video for allexcept function in dax
@vishnupp1478
@vishnupp1478 7 ай бұрын
Thanks for the video. helpful
@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.
@narasimharao4551
@narasimharao4551 3 жыл бұрын
Send link entire dax functions
@iamdhruvinshah
@iamdhruvinshah 3 жыл бұрын
Work IN Progress!! More Videos come during next 30 Days. Still few are available kzbin.info/aero/PLib8Q64STW-uiLY00WeYHfLkQbR3G4Ydd
@skawflat1115
@skawflat1115 Ай бұрын
Thanks very helpful
@jesusdariomosquera7762
@jesusdariomosquera7762 9 ай бұрын
gracias,, excelente, saludos desde Colombia
@mdsamadulislam3276
@mdsamadulislam3276 Жыл бұрын
Thank you vary much to your Awesome tuts.
@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.
@hareeshreddy4875
@hareeshreddy4875 2 жыл бұрын
pls provide average dax command practice file
@jaybuddhadev3543
@jaybuddhadev3543 2 жыл бұрын
Thanks for the simplest explanation. very easy to understand
@venkatagiriprasad9149
@venkatagiriprasad9149 2 жыл бұрын
So nice sir, great explaination 🙏🙏🙏
@mr.prasadyadav
@mr.prasadyadav 2 жыл бұрын
Clear Explanation , Thank you Sir
@vinodkumarhs4000
@vinodkumarhs4000 2 жыл бұрын
Summarize function
@deependrasingh2700
@deependrasingh2700 2 жыл бұрын
Nice informative video 👍👍👍
@sandipansarkar9211
@sandipansarkar9211 8 ай бұрын
Finished watching
@furiocamilo5108
@furiocamilo5108 3 жыл бұрын
What a great video, really enjoyed it.
@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
@abubakarjamadar7889
@abubakarjamadar7889 2 жыл бұрын
Best explanation
@londonengland2309
@londonengland2309 2 жыл бұрын
Thank you ♥️🙏
@Shreyansi1697
@Shreyansi1697 2 жыл бұрын
Nice
@meenakshik2799
@meenakshik2799 2 жыл бұрын
Thank you....
@sivajigade5053
@sivajigade5053 3 жыл бұрын
Resource file plz
@iamdhruvinshah
@iamdhruvinshah 3 жыл бұрын
github.com/Dhruvinshah16/Power-BI/tree/master/Power%20BI%20-DAX/COUNT
@sivajigade5053
@sivajigade5053 3 жыл бұрын
Thank you ji
@karrikoti5650
@karrikoti5650 3 жыл бұрын
Please send data
@iamdhruvinshah
@iamdhruvinshah 3 жыл бұрын
github.com/Dhruvinshah16/Power-BI/tree/master/Power%20BI%20-DAX/COUNT
@vishnupriya5044
@vishnupriya5044 9 ай бұрын
This is more useful to me thank you sir ❤
DAX Beginners - SUM Vs SUMX in Power BI - What, When and Where?
6:21
SHAPALAQ 6 серия / 3 часть #aminkavitaminka #aminak #aminokka #расулшоу
00:59
Аминка Витаминка
Рет қаралды 2,1 МЛН
The Joker wanted to stand at the front, but unexpectedly was beaten up by Officer Rabbit
00:12
Как подписать? 😂 #shorts
00:10
Денис Кукояка
Рет қаралды 8 МЛН
Learn all types of Date and Time Dax functions in Power Bi (35 min.)
35:21
Power BI Tutorials
Рет қаралды 54 М.
IF EAGER DAX function in Power BI
7:29
Dhruvin Shah
Рет қаралды 3,3 М.
All vs Allselected vs Allexcept DAX | Power BI Interview
12:25
LearnWidGiggs
Рет қаралды 24 М.
Creating custom visuals in Power BI with DAX
35:04
SQLBI
Рет қаралды 15 М.
No More DAX? Power BI’s NEW Feature Explained (File Included)
7:30
MyOnlineTrainingHub
Рет қаралды 125 М.
Power BI DAX Tutorial (4/50) - What is calculate Function
12:13
Analytics with Nags
Рет қаралды 112 М.
Power BI DAX logical functions - IF, AND, OR, NOT, TRUE, FALSE
13:24
Edudream digital
Рет қаралды 18 М.
SHAPALAQ 6 серия / 3 часть #aminkavitaminka #aminak #aminokka #расулшоу
00:59
Аминка Витаминка
Рет қаралды 2,1 МЛН