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

If you don't want Power BI to aggregate, don't feed it groupings. It's what it does. One could say it is one of the main design principles of Power BI. Good luck winning that fight.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Ibendlin, 


    thanks for your reply! 

    Could you explain what you mean bei groupings and where I used one?  Do you mean the rankx Call? 

    I just don't get how the level of Aggregation changes with the fields I use in a visual.