Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello. I have a table, for example:
Shop1 Product 1
Shop1 Product 2
Shop1 Product 3
Shop 2 Product 1
Shop 3 Product 1
Shop 3 Product 2
Shop 3 Product 3
Shop3 Product 4
What measure should I prescribe so that when choosing SKU, I can see only those customers who have sold all the selected SKU?
For Example
If i Select Product 1 Product 2 and Product 3
I see in table
Shop 1
Shop 3
Total: 2
If i select Product 1, i see
Shop 1
Shop 2
Shop 3
Total:3
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |