dynamic table

[jaweher899]

I've the following pbix file https://1drv.ms/u/s!Amd7BXzYs7AVk3D5iDMIrhfnpQNW?e=lHWRuH

when the user select in colun name %var, it'll add the measure %var n the table and only when both intial.subtotal and table1.Initial subtotal are selected.

for example here when initial.subtotal is not selected and %var is selected, so %var will not be added to the table

is there a way to do it pelase?

[MFelix]

Hi @jaweher899 ,

Try to add the following measure:

VAR % - VAR =
IF (
    SELECTEDVALUE ( 'Table'[ColumnName] ) = "%var"
        && COUNTROWS ( 'Parameter 2' ) = 2,
    [%var],
    IF (
        SELECTEDVALUE ( 'Table'[ColumnName] ) = "var"
            && COUNTROWS ( 'Parameter 2' ) = 2,
        [var],
        ""
    )
)

Be aware that since the Initial Subtotal slicer is a field parameter no filter is the same has both selected.

[jaweher899]

Thank you @MFelix In case of I select var and % var , it will return blank 

In case of I select nothing for the slicer column name, how to not show var-var % column by default