Count measure

[abukapsoun]

Hi Dears,

I have a simple measure but struggling to find the right forumla. 

I have the following column

X

X
X

Y

Z

I want to reach Total = (SUM of X + SUM of Y)

thanks in advance,

[v-huizhn-msft]

Hi @abukapsoun,

Please use the formula @jthomson posted, then mark the right/helpful reply as answer. If you still have other problems, please respond to us. 

Thanks,
Angelia

[jthomson · Accepted solution]

calculate(countrows(yourtablename),[yourcolumnname]="X"||[yourcolumnname]="Y")

[abukapsoun]

It worked. Thank you.