Forum Discussion
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...
Unfortunately it doesn't work i have 0 on each row when i put this measure in a table with my sales reps
Okay, a new idea mirroring your original idea:
Count of onTarget = COUNTROWS(filter(Target,Target[Column1]="OnTarget"))
Test data:
End result:
My "on target / below target" is a measure not a calculated column soo i can't try this solution 😞
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])