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
BrianConnelly's avatar
BrianConnelly
Icon for Resolver III rankResolver III
3 years ago

Have you considered pulling the data in and using Power Query to Group and Sum.  Steps would be in Power Query:

  1. Create a Conditional Column that says if InvoiceType = Item then 1 else 0
  2. Group by all the fields required and then Sum the conditional column and call it "Items"