I have the following tables:
1. "NDT" table
2. "Welding" table
3. "DER" table
|Store||DER Repair||Specify DER Repair|
4. 'General Info' table (Store column has all Store names, unlike the above 3 tables that might or might not have a full list of stores)
Here are my questions:
Question 1. Assuming Store A is selected, is there a way to count and then show all its capabilities?
Ex: In the above data, A is capable of 2 things:
Count of capabilities = 2
Details = NDT Capability (STI, FPI)
DER Repair (Yes)
Next, assuming there are 4 slicers created from the following columns:
Question 2. If Store H ( from "Store Name" slicer) & Electron Beam and/or TIF and/or Laser (from "Welding" slicer) are selected, is there a way to filter down to ONLY alternative stores that are able to do that/those thing(s)? (SINGLE/MULTIPLE SELECTIONS ON 1 SLICER)
Count of Alternatives = 5
Count of Alternatives = 1
Question 3. If Store H ( from "Store Name" slicer) & Electron Beam (from "Welding" slicer), & Radio (from "NDT" slicer) are selected, is there a way to filter down to ONLY alternative stores that are able to do both those Welding & NDT? (SINGLE/MULTIPLE SELECTIONS ON MULTIPLE SLICERS)
Please can you show me how to do this? Thank you so so much!
You may add a slicer table as slicer to display alternatives. Check the relationship and three pages in attachment for reference.
Slicer_StoreName = DISTINCT('General Info'[StoreName])
Hi @v-cherch-msft , thanks for your suggestion.
Your file seems to work perfectly the way I want it to be, however, when I did it on my file, nothing worked although everything in my file was pretty much identical to yours. None of the measures you wrote for me worked on my sample file or on my real data.
Here is the link to my file. At work, I made this file from Power BI version September 2018 (and obviously my Power BI at work is unable to open the file you posted). Therefore I had to open your file on my personal PC which has the latest version and everything worked well.
I don't know if the version is the reason? Do you have any idea why and how to tackle this issue? Thank you so much!
Question 2: Do you know if it is possible to count distinct the number of capabilities each store has using only 1 measure (that can be later put in a card visual to show the number)?
For example, if H is chosen:
Can you please advise? Thank you so much!