Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, I have following problem.
In my report I am using hierarchical slicer with AND logic - solution presented in this article:
https://medium.com/seismic-data-science/changing-or-to-and-logic-for-power-bi-slicers-1a6b20aee5f5
This is my data visualisation:
I want to know how many have fruits in selected colours, and I can do this. But now I want to know what are the other values for these filtered clients and I can't put my finger on which method I should use. Can anybody can help me with these?
Here is link to the pbix with example:
https://we.tl/t-b0cGih4nf2
Solved! Go to Solution.
Hi @DarSz ,
Since the original table has been filtered by slicer, you will need to copy it as an independent table.
Then create a measure like below and use it as visual filter.
mark =
var ids = CALCULATETABLE(VALUES(Client[ClientId]),
FILTER('Client', [HierarchySlicer Check] = 1))
return
IF(SELECTEDVALUE('Table (2)'[ClientId]) in ids,1,0)
Result:
Best Regards,
Jay
Hi @DarSz ,
Since the original table has been filtered by slicer, you will need to copy it as an independent table.
Then create a measure like below and use it as visual filter.
mark =
var ids = CALCULATETABLE(VALUES(Client[ClientId]),
FILTER('Client', [HierarchySlicer Check] = 1))
return
IF(SELECTEDVALUE('Table (2)'[ClientId]) in ids,1,0)
Result:
Best Regards,
Jay
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |