Forum Discussion
Conditional Joining two Table
Hi ALl, I have Two Table : Account No , Account Category I want to connect these two table by Accoun Number Ex: Account No : 11042-000 is want categorized Under Total Assets & Tatal Cash...
Hello @vengadeshpalani,
The Measure I created provides the behavior you're seeing,
see screenshot below, link to the sample pbix file shows pbix
Hi Anonymous ,
Don't create table relationships, just write a measure.
__amount =
CALCULATE(
SUM('Account No'[Amount]),
FILTER(
'Account No',
'Account No'[Account No] >= MAX('Account Category'[Account No Start From]) && 'Account No'[Account No] <= MAX('Account Category'[Account No End To])
)
)
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks For your Reply,
If i Click Total Assets, I want to filter out the Account No Related to Total Assets Category
I want to see the detail level also.
Can you Please Help me to resolve this logic
Hello @vengadeshpalani,
The Measure I created provides the behavior you're seeing,
see screenshot below, link to the sample pbix file shows pbix