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.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?

Need Help

2 Replies

  • 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