Forum Discussion

jaweher899's avatar
jaweher899
Impactful Individual
3 years ago

dynamic table

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.subto...
Need Help
MFelix's avatar
MFelix
Super User
3 years ago

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's avatar
jaweher899
Impactful Individual
3 years ago

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