Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
100 | |
72 | |
44 | |
38 | |
30 |
User | Count |
---|---|
156 | |
92 | |
62 | |
44 | |
41 |