Non-Numeric Measures in DAX

  • TheJimmy

    Old Hand

    Points: 386

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

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

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

  • TheJimmy

    Old Hand

    Points: 386

    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.

  • Peter Heller

    Right there with Babe

    Points: 786

    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 4 (of 4 total)

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