Forum Discussion
Anonymous
6 years agoNot applicable
Count Data based on Filter
Hello - I'm sure this is simple but I'm stumped. Below is some sample data: Agent ID Cust ID Sale 1 1 3/1/2020 1 2 3/2/2020 1 3 3/3/2020 1 4 3/3/2020 1 5 3/4/2020 ...
HotChilli
6 years agoCommunity Champion
Pull the Sale on to a card. Change the aggregation in the Values well to Count.
OR
Create a measure like CountSale = COUNT(TableX[Sale]) and drag that on to a card