Forum Discussion
bvy
Helper V
Helper VHow to UNION Tables containing a Measure using DAX or other
Given a typical Sales table with dimensions of Product and Customer (joined in the traditional way, one-to-many on ProductID/CustomerID), suppose I have a measures on the Sales table called SalesOver...
bvyHelper V
Helper V> Have you considered that this (mixing dimension values) may be confusing for your users?
No. This factors into a larger solution. Just need some DAX that will bring two tables together in the manner described.
lbendlin
Super User
Super UserYou cannot UNION dynamic tables (ie including measures) into a materialized (static) calculated table.
You would need to look into Calculation Groups and add reference columns that identify which dimension the measure should calculate for.