Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Identify Split Transactions

Hello:   I need help with identifying split transactions in Power BI. In Tableau, I was able to develop a worksheet that could identify all potential split transactions by using the following formu...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi  Anonymous ，

     

    Create a measure as below:

    Measure = CALCULATE(DISTINCTCOUNT('Table'[Payment Type]),ALLEXCEPT('Table','Table'[Employee name],'Table'[vendor],'Table'[Transaction date]))

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi!

 

 Unfortunately, I am unable to share the data as it is company sensitive - please refer to the example below. What I am trying to do is identify any potential split transactions. A split transaction is when an employee is submitting expenses through different payment methods to avoid providing a receipt and stay under the policy limit. Please note that in the example below the employee name, vendor, and transaction date are the same. This result would allow us to identify which transactions we need to investigate further. 

 

 

 

Thanks,

 

M

 

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi  Anonymous ，

 

Create a measure as below:

Measure = CALCULATE(DISTINCTCOUNT('Table'[Payment Type]),ALLEXCEPT('Table','Table'[Employee name],'Table'[vendor],'Table'[Transaction date]))

And you will see:

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you! It seems like I can make it work with this formula 🙂