Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello to tod ,
I need your help.
I have a table with customers and attractions, wanting to know that customers have subjected the attraction not to it. In this way cross selling of attractions that have not been suddenly made.
On the dashboard I had a filter type object which when I selected more than one attraction would give me the result as "OR" and I wanted it to be as "AND".
Customer Attraction
Cl1 | Worm |
Cl2 | Zip line |
Cl2 | Devil |
Cl1 | Devil |
Cl3 | Devil |
Cl3 | Worm |
Cl2 | Worm |
Cl3 | Zip line |
Cl4 | Worm |
Thank you!!
Solved! Go to Solution.
Hi ,
Try to create the following measure and apply it to the corresponding visual level filter.
Measure =
var count_att=
CALCULATE(COUNT('Table'[Customer]),
FILTER(ALLSELECTED('Table'),
COUNTROWS(
FILTER('Table',
EARLIER('Table'[Customer])='Table'[Customer])
)
)
)
var count_selected =
CALCULATE(
DISTINCTCOUNT('Table'[Attraction]),
ALLSELECTED('Table')
)
return IF(count_selected=count_att,1,0)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi ,
Try to create the following measure and apply it to the corresponding visual level filter.
Measure =
var count_att=
CALCULATE(COUNT('Table'[Customer]),
FILTER(ALLSELECTED('Table'),
COUNTROWS(
FILTER('Table',
EARLIER('Table'[Customer])='Table'[Customer])
)
)
)
var count_selected =
CALCULATE(
DISTINCTCOUNT('Table'[Attraction]),
ALLSELECTED('Table')
)
return IF(count_selected=count_att,1,0)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello
I want to use the object "data segmentation" and that works with an "and" and not with an "or". When you have two options selected from the object, the result is reflected in the table I have created.
Thank you!
You need a detached table for the attractions slicer. Then use VALUES() for the customer attractions and compare it via INTERSECT() to the FILTERS() of the detached table. If the tables match then the customer has attended all selected transactions. Or you can identify which of the selected attractions the customer has not visited by using EXCEPT()
Hello
I created the table, but the rest of the functions I have never used them, can you give an example?
Thank you!!
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |