Forum Discussion

topalych's avatar
topalych
Frequent Visitor
9 years ago

Formula DAX such as COUNTIF in Excel

Hello! Help me please.  I need formula DAX. There is a table:   Campaign    Cost     ClientID First            900        0001 First            900        0002 First            900        0003...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi topalych,

 

Vvelarde's formula seems well, you can also use blew formula:

 

Measure:

 

Current Cost = 
var currCampaign=LASTNONBLANK(Table1[Campaign],[Campaign])
Return
DIVIDE(MIN([Cost]),COUNTAX(FILTER(ALL(Table1),[Campaign]=currCampaign),[Campaign]))

 

 

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi topalych,

     

    Can you share us some sample data to test?

     

    >>And how can I add screenshots here?

    You can use the camera button to insert the picture.

     

    Regards,

    Xiaoxin Sheng

    • topalych's avatar
      topalych
      Frequent Visitor
      9 years ago

      Yes, course!

      What eMail?

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi topalych,

         

        You can upload to 1drive and share a link.

         

        Regards,

        Xiaoxin Sheng