Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
I would like to create a filter that gives the option for the user to only see the products in common by all the selected customers. So, to see which products were bought by ALL the selected customers.
For my analysis it is interesting to see the ABC table. However, if it is better to do a formula with a numeric metric, it is possible to use quantity because when there is no quantity sold, there is no ABC classification for us.
Is it possible to achieve this?
Below is the link of the dummy file for download:
Thank you in advance!
Solved! Go to Solution.
@jessicarocha , Product Having all customers
measure =
var _cnt = calculate(distinctcount(Sales[Customer ID]), allselected(Sales))
return
countx(filter(Summarize(Sales, Product[Product ID], "_1", distinctcount(Sales[Customer ID])), [_1] =_cnt), [Product ID])
@jessicarocha , Product Having all customers
measure =
var _cnt = calculate(distinctcount(Sales[Customer ID]), allselected(Sales))
return
countx(filter(Summarize(Sales, Product[Product ID], "_1", distinctcount(Sales[Customer ID])), [_1] =_cnt), [Product ID])
Hi @amitchandak ,
Thank you so much! This is what I need. Just another thing: is it possible to put this as a filter in a slicer and not only as a filter in each individual table?
so can be iteractive for the user?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |