Table visual to show all rows of related table except selected
I have 2 three tables that are joined BU[BUID] 1<->* BUPR[BUID] , BUPR[PRID]*<->1 Process[PRID] (because the relationship between BU and Process is many to many). I want to create a dashboard that has 2 table visuals and 1 slicer. The user can select a BU[Name] from the slicer and I want table 1 to display all Process that are related to the selected BU. I want the second table to show Process[Name] and BU[Name] for every other BU not selected in the slicer. So far I can only solve the first table if I make the relationships between the 3 tables bi-directional (which I know is not best practice) and cannot solve the second table despite trying several different dax measures. The second part of my problem seems similar to the solution provided in ‘Filter a table visual based on a slicer selection’ but this solution doesn’t have to traverse three different table. It seems like it should be possible but I have tried a lot of different ways and I can’t figure it out. Any help would be appreciated. Here are some example tables I used to test several unsuccessful attempts. BU: BUID Name 1 BU1 2 BU2 3 BU3 4 BU4 BUPR: BUID PRID 1 2 2 2 2 3 3 4 4 1 4 3 Process: PRID Name 1 Process1 2 Process2 3 Process3 4 Process4 Here is what I would like the result to be:
Create a slicer with a Mesure
Hi everyone ! I'd like to create a slicer segment with a “rate” (measure) that lets you choose a rate range. For example: Here I can select rate from 0% to 73% but it can be 5% to 13% also. I know it's easily possible in Tableau but Power BI it seems no. Can you give me a tips in DAX to do that please ? You need to know, I don't manage the dataset (power query) because it managing by IT department. Thank you a lot and have a good day, LD
Filter two tables on Multiple Criteria
Hello! this might be confusing and I can't share any data so I will do my best! I have two tables: SynthesizedItems and Failures. I have a report page dedicated to fail rate. This is just the number of fails/number of synthesized items. (measures in the failure table) Originally, I linked the two tables to a common date table. this allowed me to see the fail rate adjusted based on the users filtering by date. Then, I realized I needed to be able to break this down further. I added an additional table called DepartmentFilter and linked it to department in both the fail and synthesis tables. this seems to work. Now my question. My report has SEVERAL factors involved that users can slice their data by (all coming from the failure table) and I noticed that if the user filters to a certain customer, the fail table will filter but not the synthesized items table. (makes sense because they are not related, although customer exists as a field in both tables). Is it possible to make this method work where any filter the user applies will affect BOTH tables and therefore give an accurate rate? Is there a limit to how many common "filter" tables I can create and link to both? Is there a way to do it other than creating tables for each field? really trying to avoid this since it would be about 10 fields.
