Тёмный

POWER BI - DAX (COUNTROWS, CALCULATE, FILTER, ISBLANK, IF) with GAUGE CHART 

Rahim Zulfiqar Ali
Подписаться 43 тыс.
Просмотров 24 тыс.
50% 1

POWER BI - DAX (COUNTROWS, CALCULATE, FILTER, ISBLANK, IF) with GAUGE CHART.

Опубликовано:

 

8 сен 2019

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 36   
@jweiwei
@jweiwei 4 года назад
You are an absolute genius. Been searching for days of a way to countrows with a specific value as filter without luck. You did it in minutes. You have all my support.
@Alan-ps2ul
@Alan-ps2ul 2 года назад
THANK YOU! Been struggling to sort some RAG conditional formatting based on % and using ROWS cracked my problem! I'm very glad of your clear video - thanks!
@amychung8855
@amychung8855 Год назад
Thank you soooo much! It’s easier to understand without too many useless information! Appreciate that🤩
@ExcelBasement
@ExcelBasement Год назад
You’re welcome 😊
@joemccarron09
@joemccarron09 3 года назад
Thank you so much for this. I have been stuck on this for hours and now and this has solved the problem I had and now understand the filter function too (I think).
@CTajuara
@CTajuara Год назад
Thank you so much! This was extremely helpful!
@ExcelBasement
@ExcelBasement Год назад
You're so welcome!
@balrajvirdee1087
@balrajvirdee1087 3 года назад
Thanks so much, this is what I have been looking for, much appreciated 👍🏽
@bloodyjoker014
@bloodyjoker014 4 года назад
This is what I've been looking for. You earn my subscription Sir!
@virgie1728
@virgie1728 3 года назад
Thank you for this video, you just saved my day, God bless you more!!!💖💖💖
@ExcelBasement
@ExcelBasement 3 года назад
You are so welcome!
@w13ken
@w13ken 2 года назад
Good video. Quick tip: Just add +0 to the end of your measure and it will change (BLANK) to zero without the use of the IF and ISBLANK functions.
@ExcelBasement
@ExcelBasement 2 года назад
Thanks for the info!
@noor-e-sahar9667
@noor-e-sahar9667 4 года назад
You are great seriously
@Learn_Free_Excel
@Learn_Free_Excel Год назад
Thank you for making this video, pls upload more video of DAX
@ExcelBasement
@ExcelBasement Год назад
More to come!
@nancmadi
@nancmadi 4 года назад
Thank you SO much... I didn't know how to include two criteria.. learning the | | pipe symbols was awesome.. and all the other tips were great too, thank you so very much, quick and simple when your in a hurry and need a resolution fast. thank yo
@BuntriGuyTech
@BuntriGuyTech 4 года назад
Hi, please check out my Power BI channel. ru-vid.com/show-UCO7sBxy0IxBm2XKt8eV7f1g
@theking76
@theking76 4 года назад
Oh yes !! Thanks
@vijaykishan8649
@vijaykishan8649 3 года назад
Thank you so much sir for this video.
@ExcelBasement
@ExcelBasement 2 года назад
Most welcome
@holskov
@holskov 4 года назад
Thank you for the nice video. I am trying to count specific words in a collum. When I try to do that, at am told, that it need to be a number to be counted...Do you have any suggestions how to do that in Power Bi?
@md.arafat7403
@md.arafat7403 4 года назад
Thanks...your tutorials are very easy to understand.I like it and also subscribed.Could you please share more necessary DAX functions/formulas in upcoming videos.
@BIprofessional80
@BIprofessional80 4 года назад
nice video...is there any function of forecasting in DAX?
@jayanthim2039
@jayanthim2039 2 года назад
Nice information
@ExcelBasement
@ExcelBasement 2 года назад
Thanks
@abdulqadeerkamangar6279
@abdulqadeerkamangar6279 3 года назад
How can we identify top 3 by count column... Based on another column product or countries
@davidoliverninahuamanhurta4755
@davidoliverninahuamanhurta4755 3 года назад
nice, thanks so much.
@ExcelBasement
@ExcelBasement 3 года назад
You are welcome!
@pakipower
@pakipower 3 года назад
Hi I think in the 3rd example, "Yes And Excluded", you used the pipes || which do not represent AND (&&) instead these are for "OR" (||) You have to change the name of this example from YesandExcluded to YesORExcluded because that is what the formula returns. Apart from above, I also think in this example by using FILTER function we over kill the calculation, it could have been neatly done by using simple boolean filter like: YesORExcluded=Calculate (Countrows(table1), table1[Status] = "Excluded" || table1[Status] = "Yes") My 2 cents...
@Jamel1007
@Jamel1007 3 года назад
may be good to show the table data to get familiar first
@sktneer
@sktneer 4 года назад
|| symbol is equivalent to OR criteria whereas && symbol is equivalent to AND criteria. Please correct me if I am wrong.
@rahimzulfiqarali
@rahimzulfiqarali 4 года назад
&& (double ampersand) Creates an AND condition between two expressions that each have a Boolean result. If both expressions return TRUE, the combination of the expressions also returns TRUE; otherwise the combination returns FALSE. || (double pipe symbol) Creates an OR condition between two logical expressions. If either expression returns TRUE, the result is TRUE; only when both expressions are FALSE is the result FALSE.
@sktneer
@sktneer 4 года назад
@@rahimzulfiqarali That's what I said too.
@humzahaneef7256
@humzahaneef7256 Месяц назад
Urdu language?
@sudipsen3677
@sudipsen3677 Год назад
|| is or symbol
Далее
When to use SUM and SUMX in DAX
15:48
Просмотров 23 тыс.
Related and RelatedTable in DAX
8:48
Просмотров 53 тыс.
Understanding CALCULATE in DAX: Filters
18:01
Просмотров 18 тыс.
How to Use the CALCULATE Function in Power BI
19:31
Просмотров 58 тыс.