Forum Discussion
Combining measures
Here is one way that might work for you.
Credit Debit Ration =
var summarytable = SUMMARIZE (
RP_TR_TRANSACTION_DETAILS,
RP_TR_TRANSACTION_DETAILS[As of Date],
RP_TR_TRANSACTION_DETAILS[account_cd],
"TotalCount", Sum(RP_TR_TRANSACTION_DETAILS[Amount])
)
var credit = SUMX (
Filter(summarytable,[TotalCount] >0)
[TotalCount]
)
var = debit = SUMX (
Filter(summarytable,[TotalCount] <0)
[TotalCount]
)
return credit/debit
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
@mahoneypat amitchandak @darlove @Greg_Deckler
Thank you for the DAX. But its not working as expected. The values are way off the actual values.
Is there any other way in which i can combine both the measures (Credit or Debit) into a single ome.
Any help would be appreciated.
- amitchandak6 years agoSuper User
Anonymous , Can you share sample data and sample output. Looking at formula difficult to say now.
- dax6 years agoCommunity Support
Hi Anonymous ,
I am not clear about your requirement, if possible could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.