Count of invoices below threshold DAX
Hi, I m trying to create a measure to count number of invoices below threshold, threshold table is defined as below. my measure is working somehow but not giving total number of invoices, there is something wrong. kindly need assistance. Filelink Invoice Count Below threshold = VAR CurrentInvoiceAmount = [Inv. Amt SAR] VAR ThresholdValue = CALCULATE( MAX(Matrix_Invoice_Value[Value]), TREATAS( VALUES(Route_Master[Country]), Matrix_Invoice_Value[Country] ), TREATAS( VALUES(Customer_Master[Trade Category]), Matrix_Invoice_Value[Customer Type] ), TREATAS( VALUES(Route_Master[Route Type3]), Matrix_Invoice_Value[Route Type3] ), TREATAS( VALUES(Route_Cat[Attribute]), Matrix_Invoice_Value[Attribute] ) ) RETURN CALCULATE( [Invoice Count], FILTER( Daily_invioces, AND( NOT (ISBLANK(ThresholdValue)), CurrentInvoiceAmount < ThresholdValue ) ) ) threshold table Measure result: Data model
