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.
Hi everyone,
I have the following tables:
1. "NDT" table
Store | NDT Capability |
A | STI |
A | FPI |
B | Radio |
B | FPI |
D | FPI |
D | STI |
E | Radio |
T | STI |
T | FPI |
T | Radio |
H | Radio |
2. "Welding" table
Store | Welding Capability |
H | TIG |
H | Laser |
H | Electron Beam |
B | TIG |
B | Laser |
T | Electron Beam |
T | Laser |
T | TIG |
O | Laser |
C | Laser |
C | TIG |
J | TIG |
3. "DER" table
Store | DER Repair | Specify DER Repair |
A | YES | Explantion |
B | NO | |
C | NO | |
D | NO | |
E | NO | |
F | NO | |
H | NO | |
J | NO | |
K | NO | |
L | YES | Explantion |
O | YES | Explantion |
T | NO |
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)
StoreName | Address |
A | USA |
B | UK |
C | Canada |
D | Japan |
E | USA |
F | UK |
H | USA |
J | USA |
K | Singapore |
L | France |
O | France |
T | France |
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:
Expected result:
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)
Expected Result:
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)
Expected Result:
Please can you show me how to do this? Thank you so so much!
Hi @trdoan
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])
Regards,
Cherie
Hi @v-cherch-msft , thanks for your suggestion.
Question 1:
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.
My file:
Your file:
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!
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 |
---|---|
114 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |