COUNT, COUNTA, COUNTAX, COUNTX - DAX Guide

Подписаться 105 тыс.

Просмотров 23 тыс.

50% 1

COUNT: Counts the number of rows in the table where the specified column has a non-blank value.
dax.guide/count/
COUNTA: Counts the number of values in a column.
dax.guide/counta/
COUNTAX: Counts the number of values which result from evaluating an expression for each row of a table.
dax.guide/countax/
COUNTX: Counts the number of values which result from evaluating an expression for each row of a table.
dax.guide/countx/
This video is part of DAX Guide, the online guide to all the DAX functions, with links to related content and compatibility matrix with all the versions of Power BI, Azure Analysis Services (AAS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), and Power Pivot for Excel.

How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-defin...
Code, run, and share DAX with DAX.do: dax.do/?aff=yt

#dax #powerbi #ssas #tabular #analysisservices #powerpivot

Наука

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

21 мар 2021

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 9

@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!

@hmhkh 3 года назад

Hi Thanks for the hints Any recommendation regarding "distinctcount" for a large hierarchy of dimensions

@sandeepbarge4699 3 года назад

When used in case of boolean value how does COUNTA behaves differently than COUNT? Can you please clarify?

@Bharath_PBI 3 года назад

Thank you 👍. One question, why does DAX studio loses connection rapidly when connected to power bi premium dataset?

@SQLBI 3 года назад

You have to increase the timeout in DAX Studio to 60 or 90 seconds. It's a performance issue in XMLA endpoint that we hope MS will solve sooner or later.

@Bharath_PBI 3 года назад

@@SQLBI Ok, Thank you. This is helpful 👍👍 Looks like it's default set to 120 seconds (Max).