Forum Discussion
Calculated Table using SELECTEDVALUE
Hi ww1711 ,
Unfortunately, a Calculated Table is evaluated upon refresh of the datamodel. Thus selecting a slicervalue doesn't return a new evaluated calculated table.
What might be a solution to your problem is to merge both table A and B in total with an additional column "SourceTable" that has value A for all rows that come from Table A and has value B for all rows from Table B. This then can be Table C. If you put the column "SourceTable" in the slicer, you can have filtered contexts of Table C in the matrix.
Hope this explanation makes sense, if not please let me know!
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Hi ww1711 ,
Unfortunately, a Calculated Table is evaluated upon refresh of the datamodel. Thus selecting a slicervalue doesn't return a new evaluated calculated table.
What might be a solution to your problem is to merge both table A and B in total with an additional column "SourceTable" that has value A for all rows that come from Table A and has value B for all rows from Table B. This then can be Table C. If you put the column "SourceTable" in the slicer, you can have filtered contexts of Table C in the matrix.
Hope this explanation makes sense, if not please let me know!
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Hey ww1711 ,
next to JarroVGIT suggested it's also important to know, that the DAX formula can not return a table object or a column object.
This is one of the reasons (but not the most important one) why it's simply not possible to swap the axis of a visual or the row/column headers of a table or matrix visual.
So, it's necessary to have a column that contains all the possible values and create a measure that "maps" the values from the source tables in accordance with the selections made by the user.
The most simple way is to merge the tables as suggested by JarroVGIT and "typed" by mwegener.
Regards,
Tom