cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
trdoan Member
Member

Display all alternatives to the selected value

Hi everyone,

 

I have the following tables:

 

1. "NDT" table

StoreNDT Capability
ASTI
AFPI
BRadio
BFPI
DFPI
DSTI
ERadio
TSTI
TFPI
TRadio
HRadio

 

2. "Welding" table

StoreWelding Capability
HTIG
HLaser
HElectron Beam
BTIG
BLaser
TElectron Beam
TLaser
TTIG
OLaser
CLaser
CTIG
JTIG

 

3. "DER" table

StoreDER RepairSpecify DER Repair
AYESExplantion
BNO 
CNO 
DNO 
ENO 
FNO 
HNO 
JNO 
KNO 
LYESExplantion
OYESExplantion
TNO 

 

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)

StoreNameAddress
AUSA
BUK
CCanada
DJapan
EUSA
FUK
HUSA
JUSA
KSingapore
LFrance
OFrance
TFrance

 

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:

  • NDT Capability: STI, FPI
  • DER Repair: Yes

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: 

  • Store Name  - 'General Info'[StoreName]
  • DER Repair - 'DER'[DER Repair]
  • Welding - 'Welding'[Welding Capability]
  • NDT - 'NDT'[NDT Capability]

 

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:

  • With 'H' 'Laser' selected, alternatives to H = H, B, T, O, C   

         Count of Alternatives = 5

 

  • With  'H' & 'Electron Beam' & 'Laser' selected, alternatives to H = T

         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:

  • With 'H' & 'Electron Beam' & 'Radio' selected, alternatives to H = T

 

Please can you show me how to do this? Thank you so so much!

2 REPLIES 2
Community Support Team
Community Support Team

Re: Display all alternatives to the selected value

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
trdoan Member
Member

Re: Display all alternatives to the selected value

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:

Capture.JPG

Your file:

Capture.PNG

 

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:

  • the number of capabilities it is capable of = 2
  • list of capabilities = Welding ; NDT

Can you please advise? Thank you so much!