Forum Discussion

amitchandak's avatar
amitchandak
Super User
6 years ago

RanjanThammaiah , for Adv Solution you do not have Audit Data. Both slicer are filtering then there is not data

 

  • RanjanThammaiah's avatar
    RanjanThammaiah
    Helper V
    6 years ago

    amitchandak Yes, I don't have any data. The table(Comparision SSL) I have created to get the intersecting count.(Without that table I can't get the Cross-selling/Count by SSL)

     

     

    For Eg.

     

     

     

    Cross-selling formula that I have used to get the count is.

     

    Cross Selling =
    VAR InitialPurchase =VALUES('S&P'[UDN])
    VAR ComparisionPurchase =CALCULATETABLE(VALUES('S&P'[UDN]),
    ALLSELECTED(SSL),
    TREATAS(VALUES('Comparision SSL'[SSL]),'S&P'[SubServiceLineGroupingDesc]))
    Return
    IF(SELECTEDVALUE(SSL[SSL])=SELECTEDVALUE('Comparision SSL'[SSL- Copy]),
    BLANK(),
    COUNTROWS(INTERSECT( InitialPurchase, ComparisionPurchase)))

     

     

    This is what I was working on to get the count(Cross-selling) and I was looking to get the total value for each intersecting count.