Forum Discussion

jakeryan56's avatar
jakeryan56
Icon for Advocate II rankAdvocate II
8 years ago

Count based on multiple conditions

Hi, I have a requirement that I am having trouble wrapping my mind around even though it is probably simple.    I have a table called SalesData. It contains various attributes about a sale and belo...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Try this measure

 

Invoices with 1 item sold = COUNTROWS(FILTER(SUMMARIZE(VALUES(Sales_Data[Invoice]),[Invoice],"ABCD",COUNTA(Sales_Data[Description])),[ABCD]=1))

 

Just change the filter condition to 2,3 etc. for computing other measures.

 

Hope this helps.