Forum Discussion

Touaibia's avatar
Touaibia
Frequent Visitor
4 years ago

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...
CALCULATE
DAX
error
Filter
ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

Okay, a new idea mirroring your original idea: 

Count of onTarget = COUNTROWS(filter(Target,Target[Column1]="OnTarget"))


Test data:


End result:

 

 

Touaibia's avatar
Touaibia
Frequent Visitor
4 years ago

My "on target / below target" is a measure not a calculated column soo i can't try this solution 😞

  • ValtteriN's avatar
    ValtteriN
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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])