Forum Discussion
Solved
Adding rows to a table
Hello, I have a data table with 3 columns: Year, Class, Student wich I get from Query, and a Dim_school table School Class School I Class A School I Class B School I Class C ...
Hi VietNor
You can duplicate the query, rename School to Class and Append the duplicate to the original. This approach will add an extra overhead in the ETL process so this can cause refresh to take longer dependin on the data size.
You can also create a separate dimensions table with a single column for both class and school but since both are not in the same column in the fact table, you must use a disconnected table approach and filter the visual indirectly using measures.
Please see the attached sample pbix.
Hi VietNor,
May I ask if you have resolved this issue? If so, please mark it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.