Forum Discussion

RP_OFaustino's avatar
RP_OFaustino
Helper I
19 days ago
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...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    10 days ago

    RP_OFaustino 

    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
     
ajaybabuinturi's avatar
ajaybabuinturi
Super User
18 days ago

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.