Forum Discussion

abukapsoun's avatar
abukapsoun
Icon for Post Patron rankPost Patron
8 years ago
Solved

Count measure

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...
Need Help
  • jthomson's avatar
    jthomson
    8 years ago

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

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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