Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Running count unique flag

Hi Guys,   I am new to PBI and need your help, I want to create a flag for unique workorder numbers, It is like creating a Rank for each Wonum. The senario and sample data below, Can you please hel...
Need Help
Show and Tell
Tips and Tricks
  • pnvinod's avatar
    pnvinod
    8 years ago

    Hi,

    1. Add a index column from Edit queries tab

    2. Add a Rank column 

    Rank = calculate(COUNTROWS(Table1),(FILTER(Table1, EARLIER(Table1[Index])>=Table1[Index])),Table1[Wonum]=EARLIER(Table1[Wonum]))

     

    Replace Table1 as appropriate 

     

     

     

  • pnvinod's avatar
    pnvinod
    8 years ago

    I have opened  Data View

    created New Column from Modelling Tab. I have tried with Text data for Wonum And it is working fine.

    Try to create the column with one filter on index and see if it works. Then add the second one.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

My WONUM is text data type... It will be like MJ12345, I tried to change the data type but it still throws the same error

pnvinod's avatar
pnvinod
Helper I
8 years ago

I have opened  Data View

created New Column from Modelling Tab. I have tried with Text data for Wonum And it is working fine.

Try to create the column with one filter on index and see if it works. Then add the second one.