Total of meassure is wrong - Can't make other guides work

[Anonymous]

Hi guys 

I know this has been posted a couple of times, but I cannot get the other guides to work, so i was hoping you would help me. 

I have this table: 

Customer name	Our # visits	Their # visits	Our % of total visits
Customer 1	10	90	10 %
Customer 2	20	80	20 %
Customer 3	15	75	15 %
Total	45	245	15.52 %

I need the total of "our % of total visits to be equal to 45 % and not 15.52 % 

I tried using the meassure provided by others in this forum 

MyMeasure = IF(HASONEFILTER('Sessions (SessionStats)'[Customer ID]);

DIVIDE(SUM('Sessions (SessionStats)'[Raptor sessions]);SUM('Sessions (SessionStats)'[Raptor sessions])+sum('Sessions (SessionStats)'[Non-Raptor sessions]));

SUMX('Sessions (SessionStats)';DIVIDE('Sessions (SessionStats)'[Raptor sessions];'Sessions (SessionStats)'[Non-Raptor sessions]+'Sessions (SessionStats)'[Raptor sessions]))

)

In my table:
The customer name refers to: The table "Customer" and the collumn "Costumer name" Which has a reference to the customer ID from the sessionstats table 
Our # visits refers to: The table "Sessions (SessionStats)" and the collumn "Raptor sessions" 
Their # visits refers to: The table "Sessions (SessionStats)" and the collumn "Non-Raptor sessions" 

Our % of total visits is a meassure that currently calculated: 

divide([Our # visits];CALCULATE([Our # visits]+[Their # visits]))

I hope you are able to help - since I have tried a lot to follow other guides. 

[amitchandak · Accepted solution]

Try a new measure like

sumx(summarize(Table, Table[Customer name],"_our",[	Our % of total visits]),[_our])

USe measure [ Our % of total visits]

[Anonymous]

Thank your very much! 

It worked perfectly 😄