Forum Discussion
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...
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"))
Taking out the All Selected makes the cards wrong so I feel like it is needed.
JarroVGIT
Resident Rockstar
Resident RockstarHi Reh169,
Is it possible to share your pbix file (please remove confidential data)? If you don't want to share publicly you can share via PM with me and I will have a look tonight.
Is it possible to share your pbix file (please remove confidential data)? If you don't want to share publicly you can share via PM with me and I will have a look tonight.