Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Unwanted Aggregation with dynamic Ranking

Hi,    I am trying to create a dynamic ranking measure. Lets say I have n rows after every filter operation. Now I want the rows enumerated from 1.. n, according to their original id (which is uniq...
Aggregation
minx
ranking
RANKX
  • lbendlin's avatar
    lbendlin
    5 years ago

    Let's say you have a physical table with five columns.  In Power BI you add one column to a visual.  Power BI will do a GROUPBY on that column.  You add one more column. Power BI will group by the two columns etc.

    You continue to add columns to the visual, until all columns have been added. Power BI will still do a GROUPBY !!! 

    To add insult to injury, Power BI is not case sensitive.  

     

    Have fun.

lbendlin's avatar
lbendlin
Super User
5 years ago

Let's say you have a physical table with five columns.  In Power BI you add one column to a visual.  Power BI will do a GROUPBY on that column.  You add one more column. Power BI will group by the two columns etc.

You continue to add columns to the visual, until all columns have been added. Power BI will still do a GROUPBY !!! 

To add insult to injury, Power BI is not case sensitive.  

 

Have fun.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for the explanation!

As a workaround I calculated NewFeature with NewFeature = Feature + 10^(-9) * (Index - MIN(All Indexes) . Therefore NewFeature still contains the information of Feature but is also unique due to the fact that index is unique. It is not a nice solution but at least it works as long the difference between the biggsest indext and the smallest index does not become too large.