Power BI COUNT vs COUNTA function | Count in PBI | COUNTA in PBI | Count true or false values in PBI

Опубликовано: 19 Июль 2020
на канале: Life of Business Analyst
267
4

This is a short video on finding the difference between COUNT and COUNTA function in Power BI. COUNTA can support datatype boolean count.
Apart from this we did not see any major difference between the two.
Other Videos which you might be interested:

1. Summarize Columns :    • Power BI SUMMARIZECOLUMNS function  
2. Change the color of Selected Button :    • Power BI Change Button Color on Selec...  
3. Hide and Unhide Visuals to optimize space :    • Power BI Hide and Unhide Visuals | Us...  
4. Earlier function :    • Power BI EARLIER function  
5. Selected Measure or Calculated group :    • Power BI SELECTEDMEASURE  or  CALCULA...  
6. DatesMTD, DatesQTD, DatesSYTD :    • Power BI DATESMTD, DATESQTD and DATESYTD  
7. Targets & Trend :    • Power BI Measures shown in Rows in Ma...  
8. Blank, Isblank, Isnumber, Istext :    • Power BI BLANK, ISBLANK, BLANK with I...  
9. Select Columns :    • Power BI SELECTCOLUMNS function  
10. Divide by Zero Error Handling :    • Power BI Divide by Zero Error| Divide...  
11. Mean , Median, Mode :    • Power BI Mean(Average), Median & Mode...  
12. Many to many relationship :    • Power BI Many to Many Relationship  
13. Count working days, exclude holidays :    • Power BI Network days | Count Busines...  
14. Weekly Rolling average :    • Power BI Weekly Rolling Average | Wee...  
15. Enable tabular editor :    • Power BI Enable EXTERNAL TOOLS like T...  
16. Add Columns :    • Power BI ADDCOLUMNS function  
17. Contains, Containsstring :    • Power BI CONTAINS, CONTAINSSTRING & C...  
18. Variance & Standard Deviation :    • Power BI VAR.S and STDEV.S | Variance...  
19. Row Number :    • Power BI Row_Number Over Partition by...  
20. Summarize :    • Power BI SUMMARIZE function