Forum Discussion

MHac's avatar
MHac
Regular Visitor
4 years ago

Matrix Visual - possible to add 2 different Dimension into columns

Hello,   I try the following with the matrix visual: I want to visualize the amount of different products by month and by distribution group in one matrix   Amount Jan Feb Mar EMAIL PHON...
Matrix Visual
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi MHac 
You need to CROSSFILTER the relationship between DISTRIBUTION_DIMENSION and FACT. Something like

=
CALCULATE (
    SELECTEDVALUE ( DISTRIBUTION_DIMENSION[Column] ),
    CROSSFILTER ( DISTRIBUTION_DIMENSION[PrimaryKey], FACT[ForeignKey], BOTH )
)
MHac's avatar
MHac
Regular Visitor
4 years ago

Thanks for this idea -I will try and let you know.

 

best regards