Slicer Multi selected values to Filter by Column which is not having any relation

[Anonymous]

Hi Im trying to Achieve below in Jan version of PowerBi,

i have a dimension table tblDimdate which has fldYear

and another transaction table tblTransactions which i want a caluculation of fldTranAmount based on multiselections of fldYear.

im able to achieve it for single selection but for multiselection how to pass the selected values to table which doesnt have any relation to this transaction table.

ex: CALCULATE(SUM(fldTranAmount ),ALLSELECTED(tblDimdate[fldYear])

can some one help me to rewrite this.

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/multiple-selection-in-a-slicer-to-calculate-value/td-p/277190

[Anonymous]

Thanks frend,

strange IN operators beahaves different, not working with curly braces{} when i put () it is working like charm.

#Measure =

CALCULATE(SUM(fldTranAmount ),Year(tblTransaction[date]) IN( ALLSELECTED(tblDimdate[fldYear])