Forum Discussion
Request for Assistance with Power BI Invoice Analysis Report
Hello Power BI community, I am currently developing a Power BI report focused on analyzing invoices for our organization. This report aims to provide insights into our outstanding invoices, overdue ...
Hi Anonymous ,
Add the following logic in your measure to compare the result:
VAR IsFullyCredited = InvoiceAmount = CreditedAmount
RETURN
IF(
IsFullyCredited || AdjustedRemainingAmount <= 0,
BLANK(),
AdjustedRemainingAmount
)
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I tried but its still showing the invoices. F.Y.I when calculating its actually ignoring fully credited invoices as intented. My problem is its still displaying the fully credited invoices.