Forum Discussion
Division with calculated measure
I think you should use calculated column instead of using measure for this case. Let change your measure to calculated column with similar forumal. Please let me know if this works.
Duc
Thank you for your help, unfortunately adding a Column with the IF statement still gives me the same result, showing everyone as if they've reached the "SUPER" goal, because it is still calculating the total amount sold / Total amount of Super Goal, instead of testing it row by row :(
Are all those goals column and sales in the same table? I create a sample data like yours and the formula work for me like below:
Anonymous Actually there are two different tables I get from an Excel doc.
First one has every sale every salesmen made during the week, with lots of other information (like product types and et cetera), and the second one has the goals for both the salesmen and the store for the week)
I've created a relationship between them both to create some views in which everyone can find what they need
