Forum Discussion
MULTI STEP FILTERING - MEASURE OR CALCULATED COLUMN
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!!
Hello Anonymous
My solution would do that because Table3 would be linked to Table1[CASE ID REF] which, in your example would be 1.
5 Replies
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] )
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]
Thanks for the response...
Hope that the below may provide some clarity to the question.
Hello Anonymous
My solution would do that because Table3 would be linked to Table1[CASE ID REF] which, in your example would be 1.
Ahh I understand now, thanks for the image and the help!!
