Forum Discussion

mpavlofsky's avatar
mpavlofsky
New Member
5 years ago

Perfect Invoice measure?

Hi all - I'm looking to create a "perfect invoice" measure in Power BI but I don't know the necessary DAX. Can someone help me?    Right now, I have a measure computing total number of invoices by ...
Need Help
BA_Pete's avatar
BA_Pete
Super User
5 years ago

Hi mpavlofsky ,

 

Can you provide a small sample of your fact table data please?

I'm pretty sure the solution will be to use FILTER and && conditions, but need to understand your data format.

 

*EDIT*  Try this:

_noofPerfectInvoices =
CALCULATE(
  [Invoices],
  FILTER(
    fact_sales,
    fact_sales[shortquantity] = 0
    && fact_sales[returnquantity] = 0
  )
)

 

Thanks,

 

Pete