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...
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

topalych

 

Hello, use this measure

 

CostCampaign = DIVIDE(CALCULATE(Min(Table1[Cost]));COUNTROWS(Table1))