Forum Discussion

Jackofall's avatar
Jackofall
Resolver I
7 years ago
Solved

Calculated numeric field based on text field

I have a hard time understanding the prereqs of DAX. I am playing around with a toy database to learn more about PBI. I have a table that cointains a text column named Rank. The values there are d...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi Jackofall

    I think you want to do that in a calculated column rather than in a measure. There you will not have the problems of aggregation. In a measure you do not have a row context, that is why DAX does not know what you are referring to when you write Draft_Ranking[Rank]  

  • AlB's avatar
    AlB
    7 years ago

    Jackofall

    In fact what you are doing in M is add a column

AlB's avatar
AlB
Community Champion
7 years ago

Hi Jackofall

I think you want to do that in a calculated column rather than in a measure. There you will not have the problems of aggregation. In a measure you do not have a row context, that is why DAX does not know what you are referring to when you write Draft_Ranking[Rank]  

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Jackofall

    In fact what you are doing in M is add a column

  • Jackofall's avatar
    Jackofall
    Resolver I
    7 years ago

    Thanks for the feedback.

    When I changed the Default Summarization I could sord Rank by SortOrder.

    What I would do in T-SQL is to sum(case when d.Rank = 'S' then 1 else 0 end) as 'S' so I understand where my reasoning was off. There is the aggregation Another way I force sort order is to use union and set different values  '3' as [Sortorder] then sort on that column in Report Builder. I managed to fool my self totaly. Thanks for straightening me out.