Hello there,
In my dataset, I have a set of people in rows with different sociographic attributes in the columns, like age, job, married and so on.
In addition to that, there are many columns with characteristic attributes. Most of the expressions range from 0 to 5, where 0 stands for no answer, and then it goes from "absolutely not" to "absolutely." These values represent the responses from a questionnaire.
I was building a report to analyze the frequency distribution of the characteristic attributes depending on the answers from 0 to 5.
Therefore, I performed a transformation in Power Query, and it worked fine. I created a new table for each characteristic to conduct the transformation for the frequency distribution. I unpivoted this table to convert columns into rows.
However, the filter context is not working in the report. I can't filter with the sociographic attributes. The new tables I generated use function reference by right-clicking on the original table.
Filter context is not working, and I can't create relationships between the tables due to a missing primary key.
How can I solve this problem?
Thank everybody for supporting me in this case
