Forum Discussion
Solved
Total Count in Column
Hello MVPS, I thought that this was an easy scenario but I have burned 2 days without any success. Your Help will be greatly appreciated. I have 2 questions. Here is the image of my table...
pls see if this is helpfule.
Measure = CALCULATE(COUNT('Table'[Product Name]),ALLEXCEPT('Table','Table'[Account],'Table'[Campaign Attended],'Table'[Contact]))pls see the attachment below. if this does not work, pls update the sample data
Hello RP_OFaustino,
If you're trying to show how many times each Campaign_Name__c appears in the table, CALCULATE() together with ALLEXCEPT() should do it. That keeps the campaign as your filter while dropping the other columns, so every row for the same campaign ends up showing the same count.
For the earliest responded date, MIN() is the function I will use, wrapped in CALCULATE() with the same ALLEXCEPT() grouping. Again, the grouping matters. If you want the earliest date for each campaign, use the same grouping as the count.
Can you confirm whether _M_Campaign_TotalCount is a measure or a calculated column? If you can also post the DAX you're using now, it'll be easier to suggest the smallest change.