Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have tables “MainProject” and “WorkOrder” and both have a field named DEPARTMENT.
I also have a 3rd table called “Department_Relations”. Department relations has a list of many departments, countries, and areas. (More departments than countries, and more countries than areas).
I have an active relationship from MainProject[Department] many to 1 DepartmentRel[Department].
Also have an inactive relationship for WorkOrder[Department] many to 1 DepartmentRel[Department]
I tried the following options and the putting the measure or calculated column in a slicer, but they did not “slice”.
Measure1 = CALCULATETABLE( DISTINCT('Department Relations'[xArea] ) , USERELATIONSHIP(Work_Order_Master[WMF_Department], 'Department Relations'[Department]) )
This calculated column was in the Department Relations table.
Calc1 = CALCULATETABLE( DISTINCT('Department Relations'[xArea] ) , USERELATIONSHIP(Work_Order_Master[WMF_Department], 'Department Relations'[Department]) )
I would love to hear your thoughts and ideas for one or both options from above.
Thanks
Alan
I also tried some ideas from this post but did not get anywhere.
@asjones,
Slicers don't utilize inactive relationships, thus when you create slicer using fields of DepartmentRel table, and select values in the slicer, visuals that contains WorkOrder fields will not be filtered.
In your scenario, I note that you create a new table using the following DAX. Could you please share sample data of your tables and post expected result? Also it is not possible to drag measure to a slicer.
CALCULATETABLE( DISTINCT('Department Relations'[xArea] ) , USERELATIONSHIP(Work_Order_Master[WMF_Department], 'Department Relations'[Department]) )
Regards,
Lydia
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |