Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 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
    5 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!
v-kelly-msft's avatar
v-kelly-msft
Community Support
5 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 🙂