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.

pnvinod's avatar
pnvinod
Helper I
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 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Can I know what do you mean by "Replace Table1 as appropriate" please?

  • pnvinod's avatar
    pnvinod
    Helper I
    8 years ago

    in the formula "Table1" should be replaced with the name of the Table used by you