Forum Discussion
Sum/Filter Help
I'm stumped! I have the following measure: SAS_Testing:= SAS-TESTING =
CALCULATE(SUM(Table1[AMOUNT]),ALL('Name'[NAME]),Table1[Dept]="SAS", Table1[sales_id]=0,table1[product_id]="GENOH")...
Hello,
Is your product id numeric?
In your first sample you write [product_id]="GENOH".
I'm wondering that calculate can handle this equations as filter. I expected, you have to wrap it in a FILTER formula. But obviously that's not an issue.
The column is alphanumeric (but typically contains all text). I'm wondering if max is the wrong operator to be using to handle strings