Forum Discussion

abukapsoun's avatar
abukapsoun
Post 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")

3 Replies

  • jthomson's avatar
    jthomson
    Solution Sage
    8 years ago

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

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft 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