Post reply

Non-Numeric Measures in DAX

  • December 6, 2016 at 12:07 am

    #332403

    Comments posted to this topic are about the item Non-Numeric Measures in DAX

  • December 6, 2016 at 6:29 am

    #1916203

    Seems like everything eventually works back to some sort of numeric comparison.

  • December 6, 2016 at 7:38 am

    #1916233

    I guess you can say that, but if it didn't, it wouldn't be a measure at all, but a dimension.

    It's really a technique for solving a specific business problem, and you would almost always also have the underlying numeric calculation available for use in different scenarios.

  • December 8, 2016 at 8:07 am

    #1916790

    I really enjoyed the article.

    There were some minor typos such semicolons instead of commas in the DAX formulas. Largest Population = MAX([Population]) in PowerBi and in PowerPivot there would have been a ":=" for the measure. There are inconsistencies between the PowerBi and PowerPivot products that implement DAX. Also, I would have used Population Density = divide([Total Population],[Total Area]) to handle potential divide by zero errors instead of Population Density = [Total Population] / [Total Area].

Viewing 4 posts - 1 through 3 (of 3 total)

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