Mapping Table

[NewbieJono]

Hello all, i have a mapping table to group different transactions. 

we have a scenareo where i would like to have a duplicate mapping file with different gorupings. so ending up with two different mapping files but with different groups

then i would like be able touse a filter in a report to swap back and fore between the two diffrent mapping tables.

hope this makes sense

[v-luwang-msft · Accepted solution]

Hi @NewbieJono ,

Calculated columns are only calculated when you first define them and during a dataset refresh, it will not change by filters, it is a definite value, if you expect the value changes with filter, you can only use a measure.

In a measure, columns cannot be referenced directly, MAX function in a measure can return the current value in the same row of the column.

You can learn more about measures and calculated column in this article: calculated-measures-vs-calculated-columns

And according your provided,you could  test the below steps:

base table:

Table:

TableA:

TableB:

Relationship:

Step1, create slicer table,and keep the below relationship:

Step 2,create measure:

refer = IF(SELECTEDVALUE(Slicer[Type])="A",LOOKUPVALUE('Table A'[kind],'Table A'[Type],MAX('Table'[TYPE])),LOOKUPVALUE(TableB[Kind],TableB[Type],MAX('Table'[TYPE])))

then create visual:

If you need to map multiple columns, you need to create multiple conditional measures one by one.

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[amitchandak]

@NewbieJono ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[NewbieJono]

i have a list of trasactions which are grouped using the maping table.

e.g Trasaction 1-4 are group as group A in th mapping table.

however i would like another mapping table that groups things differently (as a test for the bsuinsess)

e.g Trasaction 1-4 are group as group B in the mapping table.

i am ok creating these two mapping tables, but is there a method to switch betweeen these two tables using filters. E,g i wish to by default show the data arranged using the firs mapping table. but i would like to switch to the second if to see how things change with the different mappings.

basically, i will have two mapping tables and need to switch the relationsips between both from a filter on a page