Forum Discussion

esegovia's avatar
esegovia
Frequent Visitor
9 years ago

Highlight rows with similar amounts within a certain % difference

I am trying to create an accounts receivable report that highlights rows with similar "Current" amounts for each ID number to indicate an audit check.     The payers will be prefiltered to either "...
GilbertQ's avatar
GilbertQ
Super User
9 years ago
Hi there, so you are looking for a DAX measure which will effectively divide the ($970.00) by the $982.00 for the ID Number 5208?
  • esegovia's avatar
    esegovia
    Frequent Visitor
    9 years ago

    Correct. 

    • esegovia's avatar
      esegovia
      Frequent Visitor
      9 years ago

      Bump

    • GilbertQ's avatar
      GilbertQ
      Super User
      9 years ago

      Hi esegovia

       

      Would this not solve your issue with the measures below.

       

      Personal Portion = CALCULATE(SUM('Table2'[Current]),'Table2'[PayerName] = "Personal Portion")

Private Pay = CALCULATE(SUM('Table2'[Current]),'Table2'[PayerName] = "Private Pay")

% Difference = DIVIDE([Personal Portion],[Private Pay])

      And then if you put this into a table with the ID I got the following output?