Hello -
I need some assistance with calculating a measure. Here is what I have:
Table A:
Table B:
These two tables are joined through a bridge table by Account Number/Billing Telephone Number as both have repeating acocunt numbers and EOM Load Date values. There are other tables joined through the bridge table as well.
What I want to do on Table A is:
SUM(USOC_Charges) from Table B If A.EOM Load Date=B.EOM_Load_Date. Account Number would also be equal to Billing Telephone Number but I think that is acomplished through the bridge table.
I have tried SUMX, Calculate(Sum(Filter(... a few other things but for the life of me cannot figure out how to get this to work.
Any help is appreciated.
Matt
Create relationships between Table A and Table B by Bridge Table
Calculate sum of USOC Charges where AccountID = AccountID and EOM Load Date = EOM Load Date
Measure =
CALCULATE (
SUM ( Sheet2[ USOC_Charge ] ),
FILTER (
ALL ( Sheet2 ),
[AccountID] = SELECTEDVALUE ( Sheet2[AccountID] )
&& [EOM Load Date] = SELECTEDVALUE ( Sheet2[EOM Load Date] )
)
)
How do you want to use Period (in Table A) in visualization?
How does Period (in Table A) affect sum of USOC Charges? Could you make me clear about these?
Best Regards
Maggie
Hi @matthew_hampton,
Can you provide your data in a table format or an in Excel format as you can imagine to duplicate the information you have and give you some help is difficult to replicate the data you have by images only, also provide the bridge table and expected result.
Thank you.
Regards,
MFelix
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português
Create relationships between Table A and Table B by Bridge Table
Calculate sum of USOC Charges where AccountID = AccountID and EOM Load Date = EOM Load Date
Measure =
CALCULATE (
SUM ( Sheet2[ USOC_Charge ] ),
FILTER (
ALL ( Sheet2 ),
[AccountID] = SELECTEDVALUE ( Sheet2[AccountID] )
&& [EOM Load Date] = SELECTEDVALUE ( Sheet2[EOM Load Date] )
)
)
How do you want to use Period (in Table A) in visualization?
How does Period (in Table A) affect sum of USOC Charges? Could you make me clear about these?
Best Regards
Maggie
Helpful resources
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
