Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculated Measure not working in the Matrix

So I created a calculated measure to count the number of new customers and new customer quotes each month. See logic below. I also have a matrix where I have all the sales people listed and I want to...
Need Help
  • JarroVGIT's avatar
    JarroVGIT
    6 years ago

    Whoops sorry:

    CALCULATE(DISTINCTCOUNT('Quotes Estimates US'[Customer]),FILTER('Quotes Estimates US','Quotes Estimates US'[Job Start Year] = YEAR('Quotes Estimates US'[Customer Created Date])&&'Quotes Estimates US'[Job Start Month] = MONTH('Quotes Estimates US'[Customer Created Date])&&'Quotes Estimates US'[Customer Status] = "A"))
JarroVGIT's avatar
JarroVGIT
Resident Rockstar
6 years ago

This is a calculated column and not a measure. Therefor, the ALLSELECTED is evaluated for each row in your table. If this is a measure, it would result in a syntax error because there is no context for (for example) MONTH('Quotes Estimates US'[Customer Created Date]). In a measure, that part would never evaluate on its own, but this might work in a calculated column. Are you sure this is a measure? ❓

EDIT: This is a confirmed measure but used in different contexts.

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I created a new measure to create it and am using it in cards as shown below. But I need to add it to my matrix and when I do instead of the numbers adjusting by the salesperson they stay the same for all of the sales people. But when I filter the page by sales person the cards adjust. So what do I need to change? Taking out the all selected and just having all makes the numbers wrong.