Solved: Re: Create a Calculated Column from Different Tabl...

Anonymous · ‎05-07-2019

I'm trying to divide two columns from two different tables that are linked (1:many).

So the calculation should be: Query1(Count of Disputes) / Query2(Transactions)

The result should be 3948/41494 = 0.095 = 9.5%

I can't make it work. I tried a quick measure below but not luck there - It calculates weird

Count of Disputes divided by Count of Transactions =

DIVIDE(

DISTINCTCOUNT('Query1'[Disputes]),

COUNTA('Query2'[Transactions])

)

Any idea how to make it work?

parry2k · ‎05-07-2019

@Anonymous try this

Count of Disputes divided by Count of Transactions = 
DIVIDE(
    DISTINCTCOUNT('Query1'[Disputes]),
    SUM('Query2'[Transactions])
)

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

parry2k · ‎05-07-2019

@Anonymous try this

Count of Disputes divided by Count of Transactions = 
DIVIDE(
    DISTINCTCOUNT('Query1'[Disputes]),
    SUM('Query2'[Transactions])
)

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.