Correct Syntax

[KC_1987]

Hi, 

I have the following logic below that I have attempeted to write within Power BI but not quite getting the correct syntax for it, can anyone please advise how I resolve the attempt below into the correct syntax for Power BI so it works within my new measure please? 

if(Year='2018',
(count(Customer_No)

/ count(TOTAL ,Year='2018, Benchmark)),

if(Year='2019',
(count(Customer_No)

/  count(TOTAL ,Year = '2019', Benchmark))))

[v-lili6-msft · Accepted solution]

hi, @KC_1987 

for  if(Year='2018', in measure, you should use SELECTEDVALUE or MAX or MIN Function in it.

For example:

if(SELECTEDVALUE(Year)='2018',

If not your case, please share a simple sample pbix file and expected output.

Best Regards,

Lin