measure to get symmetrical matrix type data

[krishna_sipl]

Hello,
I need help to create a symmetrical matrix, day-wise. and also thinking that is possible or not.

pbix file : FileDownloadpdix 

it should look like this :

Explanation : 

In pbix file, Test 1 column contains all events(names), Test 2 column contains all ids,

so supposed I choose one date like
15 April 2020 then It should show me data in the symmetrical matrix(symmetrical matrix pic reference which I shared).

Like: (horizontally) 

1. 15 April: 
   1. 1st block: count of distinct ID's who has the name "Create Account" on 15th April
   2. 2nd block: show in percentage same Ids who match(at least one) with any other names(except Create Account) for 15 April
   3. 3rd block:  show in percentage same Ids who match(at least once) with any other names(except Create Account) for 16 April
   4. 4th block:  show in percentage same Ids who match(at least once) with any other names(except Create Account) for 17 April
   5. 5th block:  show in percentage same Ids who match(at least once) with any other names(except Create Account) for 18 April
   6. 6th block:  show in percentage same Ids who match(at least once) with any other names(except Create Account) for 19 April
   7. 7th block:  show in percentage same Ids who match(at least once) with any other names(except Create Account) for 20 April
   8. 8th block:  show in percentage same Ids who match(at least once) with any other names(except Create Account) for 21 April
   9. 9th block:  show in percentage same Ids who match(at least once) with any other names(except Create Account) for 22 April
2. 16 April(next line):
   
   1. 1st block: count of distinct ID's who has the name "Create Account" on 16th April
   2. 2nd block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 16 April
   3. 3rd block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 17 April
   4. 4th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 18 April
   5. 5th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 19 April
   6. 6th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 20 April
   7. 7th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 21 April
   8. 8th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 22 April
3. 17 April (next line):
   1. 1st block: count of distinct ID's who has the name "Create Account" on 17th April
   2. 2nd block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 17 April
   3. 3rd block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 18 April
   4. 4th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 19 April
   5. 5th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 20 April
   6. 6th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 21 April
   7. 7th block: show in percentage same Ids who match(at least once) with any other names(except Create Account) for 22 April

So on till 22 April

same Ids, Means which you are uniquely counting on 1st block for each date.

[v-easonf-msft]

Hi , @krishna_sipl 

I am still  confused about the  result .

For example, can you tell me how to calculate the result of  this  cell  ( April 17,2020  , <1 day ,"99.07")?

It would be better if it could be expressed with a mathematical formula with values.

Best Regards,
Community Support Team _ Eason