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
Decimal change to Whole number not working in Matrix
Hello helpers, I have dataset orginally build as Decimal (10,2) format numbers, after i loaded to Power BI, i changed the number to Whole Number, Now the dataset shows as whole number fine, but the numbers in visuals still show 2 decimal 0s. And when i select the column, it shows as Whole number Formatting: Dataset: Display in Matrix Any suggestions please? Thank you
Number value is adding to Chart as 'Count of'
I have a chart that looks like the below. When I convert this to a line and column, it automatically convert the 'PM Count' column to be 'Count of PM Count' and therefore displays the values incorrectly. Below you can see that field is clearly a numeric value and is formatted as such.
