Forum Discussion
Using rank as filter
Hi, I have a table below which shows the number of visits to a web site for each customer based on the channel. I've also created a measure to rank the channel for each customer (using RANKX). What...
Hi camargos88, see below the data
| Customer | Channel | Device | Total visits |
| A | Direct Load | Tablet | 3 |
| A | Mobile Phone | 2 | |
| A | Natural Search | Tablet | 1 |
| A | Paid Search | Tablet | 43 |
| B | Direct Load | Desktop | 17 |
| B | Direct Load | Tablet | 9 |
| B | Paid Search | Desktop | 3 |
| B | Paid Search | Tablet | 2 |
| C | Direct Load | Tablet | 3 |
| C | Natural Search | Tablet | 1 |
| C | Paid Search | Desktop | 8 |
| C | Paid Search | Tablet | 8 |
| C | Referring Sites | Tablet | 1 |
| D | Direct Load | Mobile Phone | 1 |
| D | Paid Search | Desktop | 2 |
| D | Paid Search | Mobile Phone | 2 |
| D | Paid Social | Desktop | 1 |
| E | Direct Load | Desktop | 1 |
| E | Direct Load | Mobile Phone | 1 |
| E | Paid Search | Mobile Phone | 1 |
