Forum Discussion

LuciaS1's avatar
LuciaS1
Regular Visitor
3 years ago

Cross selling matrix %

Hi!

I have created this cross selling matrix by this code 

Nakup_prod_porov =
VAR Nakup= VALUES(Data_2022[Unique])
VAR Porovnanie_S = CALCULATETABLE(VALUES(Data_2022[Unique]), ALL('Tovarové skupiny'),
                        TREATAS(VALUES('Analýza správania zákazníkov'[Kód]), Data_2022[Tovarová skupina]) )
RETURN
    IF(SELECTEDVALUE('Tovarové skupiny'[Názov])= SELECTEDVALUE('Analýza správania zákazníkov'[Názov]),
        BLANK(),
            COUNTROWS(INTERSECT( Nakup, Porovnanie_S)))

I want to make percentage matrix but this code doesn t work right.  

%Percent_Nakup_Skup =
VAR Nakup = VALUES(Data_2022[Unique])
VAR Porovnanie_S = CALCULATETABLE(VALUES(Data_2022[Unique]), ALL('Tovarové skupiny'),
                        TREATAS(VALUES('Analýza správania zákazníkov'[Kód]), Data_2022[Tovarová skupina]))
VAR Pocet_Spolu = [Pocet_nakupov]
RETURN
    IF(SELECTEDVALUE('Tovarové skupiny'[Názov]) = SELECTEDVALUE('Analýza správania zákazníkov'[Názov]),
        BLANK(),
        DIVIDE(COUNTROWS(INTERSECT(Nakup, Porovnanie_S)), Pocet_Spolu) )

There are different percentage values on same products so that not right. 

Is there some way to calculate percentage cross selling matrix

 

Thak you !

Need Help

1 Reply

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    Share some data, explain the question and show the expected result.  If possible, please ensure column/table names are in English.