Forum Discussion
Combining measures
Anonymous , Not very clear Try like
SUMX (
SUMMARIZE (
RP_TR_TRANSACTION_DETAILS,
RP_TR_TRANSACTION_DETAILS[As of Date],
RP_TR_TRANSACTION_DETAILS[account_cd],
"TotalCount", [Sum-Amount]
),
[TotalCount]
)
or
SUMX (
SUMMARIZE (
RP_TR_TRANSACTION_DETAILS,
RP_TR_TRANSACTION_DETAILS[As of Date],
RP_TR_TRANSACTION_DETAILS[account_cd],
"TotalCount", abs([Sum-Amount])
),
[TotalCount]
)
I'll make it more clear. Created a measure
Sum-Amount = SUMX (
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])
),
[TotalCount]
)
Next i need division of this measure >0 and < 0 which should be categorized as Debit and Credit respectively. Right now i'm using 2 measures as mentioned in my previous post. Is there a way that i can calculate this Debit/Credit using a single measure?
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.
Anonymous , Can you share sample data and sample output. Looking at formula difficult to say now.
