Forum Discussion
Mapping Table
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
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 RegardsLucien
3 Replies
NewbieJono ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.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
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 RegardsLucien
