Forum Discussion
Reference to a dimension table after filtering
Hello everybody, I have a DAX challenge here and hope anybody can help me out as I am unable to solve it. My datamodel based on live-connect is a star schema looking like this: T...
Thank you very much for your reply.
It is not an 1:1 connection between the tables.
Dimension1 has several transactions with different Category/product combinations, the details of the specific transation is in the dimension1 table.
In Dimension2 are the details of another process, which includes the same category/product_IDs as in Dimension1.
Sorry if it is a little confusing. Can you help me here? Thanks a lot for having a look at this!