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

  • Bill Pearson

    Ten Centuries

    Points: 1369

  • This was removed by the editor as SPAM

  • doug 27038

    SSC Rookie

    Points: 39

    Hi,
    I got this today and it looks like what I need, but when I went back to the beginning of the series I see that it was written 6 or so years ago and talks about SQL 2008R2.
    Would there be much of an issue trying to follow along with new versions of SQL?

  • pietlinden

    SSC Guru

    Points: 62735

    Not really. As a matter of fact, you don't need SQL Server at all to do any of this - as long as the data is already in Excel. The only reason you may need SQL Server here is that I think the author gets his data from a SQL Server database... other than that, SQL Server is at best tangential to the whole thing.

  • jeveritt 49576

    Newbie

    Points: 2

    Re: 2020-03-25 (first published: 2017-11-29)

    I received a link to this article from subscriptions@sqlservercentral.com via email this morning.  The URLs provided for the .pbix demo file don't work for me (404 Page not found), in Chrome or in IE.  I'm sure they were active when this article was originally published however, I was not seeking Power BI information at that time.

    If there is a new/different URL from which this file can be downloaded, please advise.  Thanks!

  • Barto24n

    Newbie

    Points: 1

    If the column contains an expression that evaluates to an empty string, the COUNTAX function treats that result as non blank krogerfeedback.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply