Forum Discussion
Solved
Column count duplicates
Hello I need to create a column that says how many times the information is repeated in a column. For example, I have a table where each row represents a sale, and in each of these rows there is th...
Hi,
Create this calculated column formula
=calculate(countrows(Data),filter(Data,Data[seller]=earlier([seller])))
Hope this helps.
Hi,
Create this calculated column formula
=calculate(countrows(Data),filter(Data,Data[seller]=earlier([seller])))
Hope this helps.
thank you so much
however I have one more problem, in the dashboard I have a data filter, how do I make this formula obey the data filter? should I create a measure instead of a column? Does this formula also work if you are going to use it in a measure?
This formula's result will not update based on a slicer selection - only measures do. Why should the count change based on a date slicer selection. Share some data and show the expected result.