Forum Discussion
gunicotra
Helper II
Helper IIslicer 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...
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
gunicotraHelper II
Helper IIN.B.: "ANNO_CAMPAGNA" means "YEAR"