Forum Discussion
Total Count in Column
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 ryan_mayu Ashish_Mathur ajaybabuinturi Olufemi7 !
My apologies for not being able to respond immediately and for not providing a detailed explanation of the problem.
Here are the details:
I applied your suggested solutions in creating the dax measures but it is displaying a much larger number.
What I did was, I referenced the transaction table in power query, then group them by concatenated Opporunity ID and Campaign name then count Rows.
Then created a relationship between the transaction table and new grouped transaction table. Making it like a reference. Then used Related Function to get the number.
It's very excel like on the approach, but it does get the me the correct number.
Again, thank you for all your help!
Hi RP_OFaustino,
Glad to hear you got the correct result, and thanks for taking the time to share what worked for you—it'll be helpful for others too.
Thank you.
Thank you v-saisrao-msft ! the experts that helped and will help me in the future are truly amazing! Will drill down on their suggestions more and apply it in my project as well.
