Forum Discussion
Solved
How to filter a filtered table?
I am using Synoptic Panel by OKViz (if it matters in this instance).
I have a calendar that counts the number of purchases from clients per day.
My table shows all the clients that have made purchases for the month. Clicking on a day in the calendar shows all of the clients that made a purchase on that day. How would I write a measure to show the original list minus those clients listed in the top table?
3 Replies
You may check the following measure.
Measure = CONCATENATEX ( EXCEPT ( ALL ( Table1[client] ), VALUES ( Table1[client] ) ), Table1[client], "," )This returns the data that I am looking for but returns it all in a single cell. Is there a way to get the results broken into rows?
