Forum Discussion

hcknbrgr's avatar
hcknbrgr
Frequent Visitor
9 years ago
Solved

Merging two Matrix tables into a single Matrix table

Hi all, fairly new to Power BI and DAX. I have created two Matrix tables. Matrix Table 1 uses Product in the Columns section to split out the counts of product purchases.  Table 2 has no Columns fie...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi hcknbrgr,

     

    It is not available to achieve that. By default, we add a column/measure into value section in a matrix visual, it will be grouped automatically. As it shows in above image, the measure/column will show for each group instance.

     

    Best regards,
    Yuliana Gu

hcknbrgr's avatar
hcknbrgr
Frequent Visitor
9 years ago

I was hoping that I could create a DAX statement that would store the values of Table 1 and then I could pull that table and the Sum of Amount from my main data table.  But I am not there yet in my understanding of DAX.

I was able to find a DAX statement that I could modify and get the desired result by hard coding each Product, but again, this needs to be updated whenever there is a new Product introduced:

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi hcknbrgr,

 

You could submit this requirement as an idea at this page:How can we improve Power BI?  If it mentioned by many users, our product team might consider adding this feature in later release.

 

Best regards,
Yuliana Gu