Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
I have 2 tables (table 1, table 2) that are connected by an ID column.
Model:
Basically, I wanted to have multiple selected values from the Item slicer and display them in the table visual with an output that has both/all of the selected slicer values that looks like this:
but it displays the selected values in an OR logic instead of showing only values that have both/all of the selected slicer values:
the last row should not be included since it only has the B item.
@Anonymous , use a measure like
measure =
var _cnt = calculate(distinctcount(Table2[Item]), allselected(Table2))
return
countx(filter(summarize(Table1, Table[ID],"_1" ,distinctcount(Table2[Item])),[_1] >=_cnt),[ID])
The count measure is already working as it only counts the valid records that have all of the selected slicer values, but how do I reflect it on my table to show only these records?
ex. in this scenario, I wanted to reflect only 1 unique record on the table visual as it displays in the measure
User | Count |
---|---|
89 | |
82 | |
51 | |
40 | |
35 |