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.
Hello,
I imagine there is some clever way to achieve this but it isn't apparent to me what the best way to go about it is. Referring to the sample data below, I would like for there to be a way to utilize the slicer on the left to see all records with the selected Home Dept, as well as records with other home departments but that have charged the Home Dept from Account 6101.
The expected result in this simple dataset when filtering for Home Dept 001 would be to return all of the 001 Home Depts, but also include Joe's 6101 account record.
Is this possible either through Dax, Power Query, or other means?
why not also 6007?
In this example, we don't want the 6007 because the Charge Department matches the Home Department and the Home Department is not 001.
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 |
---|---|
105 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |