Forum Discussion

gunicotra's avatar
gunicotra
Icon for Helper II rankHelper II
5 years ago
Solved

slicer selected choice

Hi to all, I am trying to change dynamically a measure coherently with the value of a year slicer, but this is not working properly. I have a: - Year slicer with the column of a Table1 "Table1[Yea...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    gunicotra , This kind of measure is suitable if table 1 and table 2 are not connected

     

    measure =
    var _year = allselected(Table[Year])
    return
    CALCULATE(SUM(Table2[Counter]),filter(Table2 , Table2[CODE] in {"10", "11", "12","13","14"} && 'Table2'[YEAR] in _year))

     

    because if they are connected , it will already have filter impact

     

    I explained it here

    Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

gunicotra , This kind of measure is suitable if table 1 and table 2 are not connected

 

measure =
var _year = allselected(Table[Year])
return
CALCULATE(SUM(Table2[Counter]),filter(Table2 , Table2[CODE] in {"10", "11", "12","13","14"} && 'Table2'[YEAR] in _year))

 

because if they are connected , it will already have filter impact

 

I explained it here

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

  • gunicotra's avatar
    gunicotra
    Icon for Helper II rankHelper II
    5 years ago

    great solution!  it works perfectly. Thanks 🙂