Change table based on slicer alternative

Hi mriveraa ,

As far as I know, Power BI doesn't support calculated table/column be dynamic based on slicer or filter. I suggest you to create measures to achieve your goal.

Data model:

SlcierTable1 = VALUES('Module'[Document.version])

SlcierTable2 = VALUES('Module'[Document.version])

DimModuleName = VALUES(Module[Document.modules.name])

Measure:

Difference = 
VAR _SELECT1 =
    SELECTEDVALUE ( SlcierTable1[Document.version] )
VAR _SELECT2 =
    SELECTEDVALUE ( SlcierTable2[Document.version] )
VAR _VIRTUAL_TABLE =
    EXCEPT (
        SELECTCOLUMNS (
            CALCULATETABLE (
                Module,
                FILTER ( Module, Module[Document.version] = _SELECT2 )
            ),
            "name", Module[Document.modules.name],
            "version", Module[Document.modules.version]
        ),
        SELECTCOLUMNS (
            CALCULATETABLE (
                Module,
                FILTER ( Module, Module[Document.version] = _SELECT1 )
            ),
            "name", Module[Document.modules.name],
            "version", Module[Document.modules.version]
        )
    )
RETURN
    MAXX (
        FILTER ( _VIRTUAL_TABLE, [name] = MAX ( DimModuleName[Document.modules.name] ) ),
        [version]
    )

Result is as below.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.