Is there any possibility to filter the data without table relationship

[RanjanThammaiah]

Hi All,

can someone help me to filter the data without having a table relationship?

I have data where I shouldn't create a relationship to arrive at the cross-selling numbers. but I need the Total value should be appearing for the intersecting Count.

Currently, the total on the tooltip is showing the Total value of the Column.

I have used the below DAX- which did not work.

Measure = CALCULATE([TVPS],

FILTER(ALL('S&P'),

'S&P'[SubServiceLineGroupingDesc]in VALUES('Comparision SSL'[SSL])))

attached the sample Report

Basically the tooltip should show the below value.

Help would be much appreciated.

Regards,

Ranjan

[AllisonKennedy]

Sorry, I'm not sure what you want tooltip to display and for which cells of matrix. Are you just looking at the total values in your tooltip and only for the grey diagonal cells?