Forum Discussion

askpbiuser's avatar
askpbiuser
Icon for Helper I rankHelper I
3 years ago

Sort by column values with multiple fields in rows in matrix

Hi, I need to display Country and Customer coming from different Dim tables and show them in rows in matrix visual. The field ( Product) in Columns in Matrix is from a different Dim table all connect...
some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
3 years ago

Hi askpbiuser  your part for SUMMARIZE define "later" output

SUMMARIZE('Fact','Dim Country'[Country], 'Dim Product'[Product]) 

combined with ALLSELECTED(''Dim Product'[Product]) which "missing" Dim Customer table / some column

Try to add to this part what you need, like customer.

Hope this help. Kudos appreciated.