Cross Seeling analysis Total value

[RanjanThammaiah]

Hi All,

I am doing a cross-selling analysis. Where I want the tooltip on the table shown below.  currently, the total value is showing the same value if I hover over the columns. is there any way I can filter it out by column & Row names?

Eg. From Audit to Adv soul is 92484 also it shows the same value for BTS to Adv soul. same continues for all other combinations also.

is there any way I can get the combined value of Audit & Adv soul and BTS &adv soul?

I have used the below formula to arrive this. where I have sed 2 tables for column and row.

Cross Selling =

VAR InitialPurchase =VALUES('S&P'[UDN])

VAR ComparisionPurchase =CALCULATETABLE(VALUES('S&P'[UDN]),

All(SSL),

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

Return

IF(SELECTEDVALUE(SSL[SSL])=SELECTEDVALUE('Comparision SSL'[SSL- Copy]),

BLANK(),

COUNTROWS(INTERSECT( InitialPurchase, ComparisionPurchase)))

[Icey]

Hi @RanjanThammaiah ,

How about replacing ALL with ALLSELECTED?

If this doesn't work, it is suggested to provide some sample data for test.

Reference: How to provide sample data in the Power BI Forum

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RanjanThammaiah]

Hello @Icey , Thanks for your reply.

Unfortunately, it did not work.

I have added the sample report 

Let me know if the link doesn't work.

Basically I am looking at the below-highlighted value for the 11 Count over there.

The tooltip I have added DAX.(suggested by some other member)

Measure = CALCULATE([TVPS],FILTER('S&P','S&P'[SubServiceLineGroupingDesc]in VALUES('Comparision SSL'[SSL])))