Forum Discussion
abukapsoun
Post Patron
8 years agoCount 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...
- 8 years ago
calculate(countrows(yourtablename),[yourcolumnname]="X"||[yourcolumnname]="Y")
jthomson
Solution Sage
8 years agocalculate(countrows(yourtablename),[yourcolumnname]="X"||[yourcolumnname]="Y")
abukapsoun
Post Patron
8 years agoIt worked. Thank you.