Forum Discussion

bvy's avatar
bvy
Icon for Helper V rankHelper V
4 years ago

How 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...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Have you considered that this (mixing dimension values) may be confusing for your users?

You can UNION tables in measures, but only as table variables, and only as intermediate steps, before returning a single scalar value.

  • bvy's avatar
    bvy
    Icon for Helper V rankHelper V
    4 years ago

    > 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's avatar
      lbendlin
      Icon for Super User rankSuper User
      4 years ago

      You 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.