Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have 3 tables, Sales Records, Products, Customer.
Sales Records
Customer | Product | PurchaseDate |
A | P1 | 20170101 |
A | p2 | 20170501 |
B | P1 | 20171022 |
C | P3 | 20170507 |
Is it possible to create a Product Slicer to give me all the customer who have never purchase the selected product?
For example,
in my slicer, i have the ability to choose P1 to P4. When P1 is selected, the result should display Customer C..
Product | Name | Unit Price |
P1 | n1 | 1 |
P2 | n2 | 2 |
P3 | n3 | 3 |
P4 | n4 | 4 |
Solved! Go to Solution.
You may drag [Customer] from Customer Table and the following measure to a Table visual.
flag = VAR c = MAX ( Customer[Customer] ) RETURN IF ( COUNTROWS ( FILTER ( 'Sales Records', 'Sales Records'[Customer] = c && 'Sales Records'[Product] IN VALUES ( Products[Product] ) ) ) = 0, 1 )
You may drag [Customer] from Customer Table and the following measure to a Table visual.
flag = VAR c = MAX ( Customer[Customer] ) RETURN IF ( COUNTROWS ( FILTER ( 'Sales Records', 'Sales Records'[Customer] = c && 'Sales Records'[Product] IN VALUES ( Products[Product] ) ) ) = 0, 1 )
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |