How to COUNT in Power BI | COUNT, COUNTA, DISTINCTCOUNT, COUNTBLANK,COUNTROWS , DISTINCTCOUNTNOBLANK
19.3 هزار بار بازدید -
3 سال پیش
-
In this video I go
In this video I go through the SIX different ways you can count using DAX in Power BI.
Counting is probably one of the most common functions you would've been using if you work a lot of with data. Did you know that you can do more with your COUNTS in Power BI?
Here's a TLDR version of the video if you don't want to watch the whole thing:
- COUNT - Count Non-Blank Values
- COUNTA - Count Non-Blank Values, accepts TRUE/FALSE types
- DISTINCTCOUNT - Count unique values
- COUNTBLANK - Counts blank rows
- COUNTROWS - Counts rows in table
-DISTINCTCOUNTNOBLANK - Count distinct rows ignoring blanks
#PowerBI #DataAnalytics #BusinessIntelligence #dax #bitips #bi #powerbidax
Counting is probably one of the most common functions you would've been using if you work a lot of with data. Did you know that you can do more with your COUNTS in Power BI?
Here's a TLDR version of the video if you don't want to watch the whole thing:
- COUNT - Count Non-Blank Values
- COUNTA - Count Non-Blank Values, accepts TRUE/FALSE types
- DISTINCTCOUNT - Count unique values
- COUNTBLANK - Counts blank rows
- COUNTROWS - Counts rows in table
-DISTINCTCOUNTNOBLANK - Count distinct rows ignoring blanks
#PowerBI #DataAnalytics #BusinessIntelligence #dax #bitips #bi #powerbidax
3 سال پیش
در تاریخ 1400/01/02 منتشر شده
است.
19,373
بـار بازدید شده