Total Count in Column

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.

Hello RP_OFaustino ,
I would like to let you know that this depends on whether you want the calculation to respect filters/slicers or always return the total for the entire dataset. In most Power BI reports, measures are the preferred approach.

For 1st Que Answer: Use below measure to get Campagin Name count

Campaign Total Count =
CALCULATE(
    COUNT('TableName'[Campaign_Name__c]),
    ALLEXCEPT(
        'TableName',
        'TableName'[Campaign_Name__c]
    )
)

For 2nd Que Answer: Use below measure to get Earliest Responded Date

Earliest Responded Date =
CALCULATE(
    MIN('TableName'[Responded_Date__c]),
    ALLEXCEPT(
        'TableName',
        'TableName'[Campaign_Name__c]
    )
)

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

Hi,

Does this measure work

Measure = countrows(allselected(Data[c_opp_name]))

If it does not, then please share the download link of the PowerBI file.

not clear about this request. could you pls provide some sample data and expected output?

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!

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!