Forum Discussion
Latest customer names
This seems like something simple and I'm struggling. I feel like no matter how many books I'm reading (I have 4 PQ/PBI/DAX books in front of me), this is just not working. I'm looking to list t...
The way to do it is this.
You put your customer names into a table visual (first put the names into a calculated table of its own with just 2 columns - Customer Name and CustomerID (hidden)).
Then you create a logical helper measure that for each customer in the said table will return 1 (integer) if the customer is considered new in the current filter context and 0 if not. Then use the measure to filter this visual ONLY through the Filters pane.
You put your customer names into a table visual (first put the names into a calculated table of its own with just 2 columns - Customer Name and CustomerID (hidden)).
Then you create a logical helper measure that for each customer in the said table will return 1 (integer) if the customer is considered new in the current filter context and 0 if not. Then use the measure to filter this visual ONLY through the Filters pane.