Forum Discussion

ww1711's avatar
ww1711
Frequent Visitor
6 years ago
Solved

Calculated Table using SELECTEDVALUE

Hi all,   This should be simple enough, but I can't get it to work... I've got Table A and Table B that share the same schema. I want to inspect a slicer (that chooses between 2 values in a separat...
Need Help
  • JarroVGIT's avatar
    JarroVGIT
    6 years ago

    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! 🙂

     

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi ww1711 ,

 

the calculated table would look something like this.

Table C =
UNION (
    ADDCOLUMNS ( Table A, "Source", "Table A" ),
    ADDCOLUMNS ( Table B, "Source", "Table B" )
)

 

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.