MULTI STEP FILTERING - MEASURE OR CALCULATED COLUMN

[Anonymous]

Community,

Any help with the below would be much appreciated.

Context - We work with experimental data that has images associated with the experiment that we would like to showcase in Power BI. 

1 have 2 tables, Table1 and Table2, shown below.

The 2 tables are connected by CASE ID.

Step 1

I would like to filter table1 by CASE ID, after this I would like to return the PHOTO LINK of the filtered CASE ID and the PHOTO LINK of the CASE ID REF. This step would allow us to show the photos of the CASE ID and the CASE ID REF.

Step 2

I would like to return the filtered CASE ID from above in a calculated column or measure that would have both the filtered CASE ID and CASE ID REF, such that if CASE ID 2 were selected (filtered), the column would populated with CASE ID 1 and 2. This column/measure would be used to filter the photos of the selected CASE ID and CASE ID REF.

Thanks for any possible solutions!!

[Anonymous]

@jdbuchanan71 , @parry2k 

Thanks for the response...

Hope that the below may provide some clarity to the question.

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

My solution would do that because Table3 would be linked to Table1[CASE ID REF] which, in your example would be 1.

[Anonymous]

@jdbuchanan71 

Ahh I understand now, thanks for the image and the help!!

[jdbuchanan71]

For the photos, you can make a copy of the photo table (Table2) and link the copy to the [CASE ID REF] column in Table1.  Making a copy of a table is simple  Go to Modeling > New Table and enter the formula 

Table3 = Table2

Then you link Table3[CASE ID] to Table1[CASE REF ID]

For a coulm that shows both the [CASE ID] and [CASE REF ID] you can just add a column to Table1 like

=[CASE ID] & ", " & [CASE REF ID]

[parry2k]

@Anonymous not very clear hat you are asking in step 2

for step 1, just add a new column in Table1

Photo Link = RELATED( Table2[Photo Link] )