Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
I have a table (Table A) in the following format
Table B is defined as
Solved! Go to Solution.
hi @Jos13
The relationship between TableA and TableB is based on [Signature], When you filter a date from date table, it will filter out [Signature] in tableA, then TableA will filter TableB only by [Signature] filed, it couldn't filter tableB by [date].
For example:
When you filter 1st may 2020, it will filter Signature is 772325 in TableA, then TableA will filter TableB by [Signature] field which it only is 772325 in TableB, so the result is 4 not 1.
For your case, you do not need a TableB, just use TableA will meet your all requirement.
Eg. you could just drag SUM of TableA[Event]
Regards,
Lin
hi @Jos13
The relationship between TableA and TableB is based on [Signature], When you filter a date from date table, it will filter out [Signature] in tableA, then TableA will filter TableB only by [Signature] filed, it couldn't filter tableB by [date].
For example:
When you filter 1st may 2020, it will filter Signature is 772325 in TableA, then TableA will filter TableB by [Signature] field which it only is 772325 in TableB, so the result is 4 not 1.
For your case, you do not need a TableB, just use TableA will meet your all requirement.
Eg. you could just drag SUM of TableA[Event]
Regards,
Lin
The Date table is filtering to that Date in Table A, but the bi-di relationship with Table B is on Customer, so you are getting the sum for all rows of that Customer. You should not need to create Table B and do it all with a measure on Table A. You should be able to have a simple SUM(TableA[Event]) measure and slice/dice by Signature, Date, Company, etc. in your visuals.
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@Jos13 , did not get the need of Table B, As you got that from Table A. what is that you would not have got from Table A
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |