Forum Discussion
Solved
Filter Table Results to include certain values
Hello, I have a Table listing results of promotional activity with each line showing an event, Total Sales, Total Promo Volume, etc which are input as measures. I have another column in my datas...
Have you tried this simpler expression?
Total Sales = CALCULATE(SUM('promo dbase'[Total Sales]), 'promo dbase'[Include]="Yes")
Pat
mahoneypat
Microsoft Employee
Microsoft EmployeeHave you tried this simpler expression?
Total Sales = CALCULATE(SUM('promo dbase'[Total Sales]), 'promo dbase'[Include]="Yes")
Pat
Thank you! I modified it to show the values in the table even when they are not counted by wrapping it in an "IF" statement:
Total Sales Chart = IF(CALCULATE(SUM('promo dbase'[Total Sales]), 'promo dbase'[Include]=1)>0,CALCULATE(SUM('promo dbase'[Total Sales]), 'promo dbase'[Include]=1),[Total Sales])
I changed "Yes" and "No" values to "1" and "2"