Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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. ...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    Hello Anonymous 

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

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
7 years ago

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]