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
i have excellently same 2 tables
when i put the data together is same matrix - one is give me the data i want and one is summarize all data in all rows
what is the reason ?
Thank you!
Solved! Go to Solution.
Hi @oren You should have a relationship between both the table else total value will be repeated for each row like your matrix. Accept this as solution if this solves your problem.
Thanks & Regards,
Karthick K
Hi @oren You should have a relationship between both the table else total value will be repeated for each row like your matrix. Accept this as solution if this solves your problem.
Thanks & Regards,
Karthick K
i did it and its works :
but why it didn't work for me when is did the relations with another table ??? (see below)
thanks!!
@oren Try making the filter bi directional. By the way what is there in ID Column ?
Try making the filter bi directional.
i works now! thank you!
By the way what is there in ID Column ?
it have unique numbers {1,2,3...} (so i can sort the test% by that)
thank you!
i checked it again
the problem is that i can do it for only 1 relations
if i try to do it to another value (like "TEST%") its a problem :
Have you removed the intermediate table ? you can't have two relationship between two tables. May I know why are you creating two relationships between these two tables ?
again,
my first problem was the i got a wrong data- so your solution was to make relations ,
it did help but only for the specific category , if for example i want to use a different category , i again getting a wrong data (see in yellow)
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 |
---|---|
117 | |
101 | |
68 | |
68 | |
43 |
User | Count |
---|---|
146 | |
106 | |
105 | |
90 | |
65 |