Forum Discussion
Touaibia
4 years agoFrequent Visitor
Error message with the calculate function
Hello everyone, I have a date model with : Sales table Product table Customer table In my company we have 24 products that we are pushing and I want to know how many customer purchased thi...
Touaibia
4 years agoFrequent Visitor
My "on target / below target" is a measure not a calculated column soo i can't try this solution 😞
ValtteriN
4 years agoCommunity Champion
In that case your problem should be identical to the one I had yesterday 🤔. Maybe the problem is then with SUMX table. You mentioned that you used a table with "sales rep" maybe the measure works if you change the dax like so:
SUMX('Sales rep',[Helper measure])