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?