Forum Discussion
Assistance needed with formula
You need to get familiar with the early function. It's one of those functions that I'm not totally sure why it works, I just know it does. So let's learn by doing.
So you can use this function to create a count of the rows that have each unique key. The syntax would be:
=CALCULATE(COUNTA([KEY]),FILTER('TABLENAME','TABLENAME'[KEY]=EARLIER('TABLENAME'[KEY])))
This would be the denominator in your equation, so you could just put a "1/" in front of the above equation to get your proper value.
That should work for you. Let me know.
I'm totally not following this. Perhaps paste in your source data and what you want the result to look like?
Greg_DecklerI am sorry for my inaccuracy.
For all the column "Key" I need a formula to divide 1 by the number of each duplicate.
E.g. for: 142944 =(1/4)
Key Entry Formula 142944 0,25 1/4 142944 0,25 1/4 142944 0,25 1/4 142944 0,25 1/4 242944 0,333333 1/3 242944 0,333333 1/3 242944 0,333333 1/3 342944 0,5 1/2 342944 0,5 1/2 442944 1 1/1 Hope now is clearer.
Thanks