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,
Please share the download link of the PBI file. Show the problem and expeced result there clearly.
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
