Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have records in table A (BaseInfo) that contains data on an individual, specificly their region. I then have a second table which has responses from a particular multiple choice question they may or may not have answered. For instance, suppose I have 10 records for respondents from "Europe" in table A, and of those 10, 8 answered something for a question ("Q6") but only 4 chose "C" as an answer. I want to show that 50% of the respondents from Europe who answered something for Q6 answered 'C' (4 out of 8. )
For instance this will tell me the % out of the over all respondents from the region who answered the question, i.e. 40% using the above example, not 50%:
Solved! Go to Solution.
After much experimenting, I decided to create a region column in the child table and use that. Then this works, although I am not quite sure why and perhaps there is a more elegant solution.
After much experimenting, I decided to create a region column in the child table and use that. Then this works, although I am not quite sure why and perhaps there is a more elegant solution.
I should maybe add that when I use
@R_S , Is table A is joined with Table B directly.
Or they should be joined by a dimension/bridge table.
https://www.seerinteractive.com/blog/join-many-many-power-bi/
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@amitchandak Yes, there is a one to many relationship between the two tables. I can't share the pbix due to the data unfortunately.
The only important columns would be:
Base Info table: ResponseId, Region
Q6: ResponseId, Response
E.g:
Base Info:
1, APAC
2, Europe
3, APAC
4, APAC
etc
Q6:
1, A
1, B
2, A
2, B
2, C
2, D
3, A
3, C
etc
Here we see only 1 and 3 answered Q6 from APAC (4 did not) and while both answered A (100%) only 1 answered B (50%) or C (50%)
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |