Forum Discussion

DSR's avatar
DSR
Resolver I
1 year ago

Does Excel 2016 Pro Dax does not accept Variable Only HardCode? It is giving me Error

Hello, Your help is appreciated. I loaded the tables intio the DataModel: Q1-     fVotesAmioun2016 Q2-     dCandidatesAmioun2016 Q-3     dRegionAmioun2016 Q4-     CandidateCompared      //is a v...
Deku's avatar
Deku
Super User
1 year ago
CALCULATE(
   [Tt Votes],
   fVotesAmioun2016[CandidateEN] in VALUES( CandidateCompared ) ,
   fVotesAmioun2016[Region]="Sharqi"
)
DSR's avatar
DSR
Resolver I
1 year ago

Your suggestion does not work.