Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
The solution I have in mind is:
- Two slicers: one for "BG", one for "Plant"
- The result (table or graph) should always display the target records despite the value of the slicer.
Data Structure
BG | Plant | Saving | Target | year
------------------------------------
A1 | B1 | 200 | 0 | 2023
A 2 | B2 | 200 | 0 | 2024
etc.
Target | Target | 0 | 105 | 2023
Target | Target | 0 | 205 | 2024
What I did already
First, for the slicers I made a separate table using DAX storing the BG and Plant. This table (called "Table1") has no relation with my main table
BG | Plant | Saving | Target | year | filter_plant | filter_bg
--------------------------------------------------------------------
A1 | B1 | 200 | 0 | 2023 | 0 | 0
A 2 | B2 | 200 | 0 | 2024 | 1 | 1
etc.
Target | Target | 0 | 105 | 2023 | 1 | 1
Target | Target | 0 | 205 | 2024 | 1 | 1
@IwanVB , Try like
Countrows(filter(Table1, Table1[Plant] IN VALUES('category list'[Plant]) || Table1[Plant] = "Target"))+0
or
Switch(True(),
max(Table1[Plant]) IN VALUES('category list'[Plant]) || max(Table1[Plant]) = "Target", 1,0)+0
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |