Stairway to DAX and Power BI - Level 12: Function / Iterator Function Pairs: The DAX CountA() and CountAX() Functions

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CountA() and CountAX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to CountA() and CountAX(), in counting non-empty cells in a column, and in counting nonblank results when evaluating the result of an expression over a table, respectively.

Curious Case of SUM Function

How a simple SUM statement could change an output.

Type INT

Round averages

Stairway to DAX and Power BI - Level 6: The DAX SUM() and SUMX() Functions

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson exposes the DAX SUM() and SUMX() functions, comparing and contrasting the two. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in managing “sum” aggregations within our PowerPivot model designs.

RE: How to get available memory using SQL

It's not a table : run this in the master table Select objectproperty(object_id('sysperfinfo'), 'TableIsFake') It will return 1. This means than when you query that table, Sql server meterializes it so that the query can execute, but this information is never actually kept on the hd like a real table. checks BOLS : objectproperty::TableIsFake

RE: "I renamed the file and it does not work"

One of our customers stated he didn't need backups copied to a safe place. When he tested his backup-power-system there was this litle problem where in stead of 220V the server got a slam of 360V. Ofcourse there was some damage. Fortunatly we had a set of recent images we could restore. We needed +- […]

RE: Logins

i did the same and works fine for me ... strange thing, may be something is wrog in the second computer, try in a third computer

RE: xSQL: User Experiences ?

Hi,plaese try "SQL server compare" ( freeware ) .. just 1Mb and very user friendly.GKramer

RE: What are DR2 files?

You may be getting this error message when the file you transfer contains a DRI in this case a non clustered index. Regards