Forum Discussion
Solved
Create a Distinct Count Column that can be summed to get a Distinct Count Total
Hello - I am trying to create a new column that will contain a fraction that when summed, it will equal the total number of distinct counts for a column. In the Example Below, the Value I am trying ...
A new column = 1/ countX(filter(Table, [Column 1] = earlier([Column 1])), [Column 1])
Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
amitchandak
Super User
Super User
A new column = 1/ countX(filter(Table, [Column 1] = earlier([Column 1])), [Column 1])
Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8