Forum Discussion

bidataservices's avatar
bidataservices
Frequent Visitor
3 years ago

COUNTIFS in DAX

Can anybody please help with a DAX question. I have a report in Excel that counts the items that make up an invoice. I have atached a screenshot with the Excel formula highlighted. I am trying to rec...
CountIfs
DAX
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi bidataservices 

 

try like:

column =
VAR _count =
COUNTROWS(
    FILTER(
       TableName,
       TableName[InvoiceType]="Item"
&&TableName[InvoiceType]=EARLIER(TableName[InvoiceType])
&&TableName[Document]=EARLIER(TableName[Document])
&&TableName[Item]=EARLIER(TableName[Item])
&&TableName[City]=EARLIER(TableName[City])
    )
)
RETURN
IF(
   [InvoiceType]<>"Item",
   _count
   )
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi bidataservices 

try like:

column = 
VAR _count =
COUNTROWS(
    FILTER(
       TableName,
       TableName[InvoiceType]="Item"
        &&TableName[Document]=EARLIER(TableName[Document])
        &&TableName[Item]=EARLIER(TableName[Item])
        &&TableName[City]=EARLIER(TableName[City])
    )
)
RETURN
IF(
   [InvoiceType]<>"Item",
   _count
)

 

it worked like: