Forum Discussion
DAX HELP
I have order quantity and invoiced quantity. In some cases, we will delete sales order, so the order quantity will be blank and invoiced quantity will be there. And I want to show order quantity an...
So if i understand correctly you want the sum of order quantity and the sum of invoiced quantity, but dont count the invoiced quantity if order quantity is empty?
If this is the case you can make a measure something like this, could be a little off as i have no sample data:
Measure = CALCULATE(SUM(InvoicedQuantity);OrderQuantity <> BLANK())
for OrderQuantity you can just do
Measure = SUM(OrderQuantity)
If this is not what you need please consider reading this and give a bit more information:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
In my case, Order quantity and invoiced quantity are from different table, and order is the common link between these two tables.