Forum Discussion
Calculated Measure based on two different slicers
Hi, I have two slicers that comes from different tables. Now need to create a measure based on these slicers. For example, If one slicer is of date table The other slicer is from dept table Ne...
Anonymous , if they joined with the table if the filter automatically . If they are disconnected
calculate([measure],filter(Table, Table[date] in allselected(Date[date]) && Table[dept ] in allselected(dept [dept])))
calculate([measure],filter(Table, Table[date] in values(Date[date]) && Table[dept ] in values(dept [dept])))