Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |