Forum Discussion

dilbagsidhu's avatar
dilbagsidhu
Frequent Visitor
2 years ago

slicer edit interaction issue

Hello, i have card which shows candidate winner in election year 2014 for which function is

candidateWin2014 =
VAR maxvotes= MAX(Results[Total votes])
RETURN
CALCULATE(MAX(Results[Candidate]),FILTER(Results,[Total Votes]=maxvotes),Results[Year]=2014)

it works fine if i dont disable its interaction with year slicer, which has 2 year "2014", "2019".
but when i disable its interaction, for some constituencies(places where elctions were held) it shows value and for some it shows (blank).
So what could be the possible reason..
do shar eyour insight.
im attaching video link showing the issue.


https://drive.google.com/file/d/1eDciGl8qlBORyPevT8aWcZztqw4ez3x9/view?usp=drive_link

5 Replies