i am having below table in power bi.
id name date
1 A 30-April-2023
2 A 30-April-2023
1 A 30-April-2023
4 A 30-April-2023
2 B 30-April-2023
I B 30-April-2023
Now my requirement is need a pivot table visual like motioned below.
A B
A 3 1/2(50%)
B 1/2(50%) 2
example if A to A total distinct ID count is 3, and A to B is one part is shared among total parts of of b which is 1/2 nothing but 50%
This used to happen based user selection in slicer which is date.
Is above one is possible in DAX? if yes, I kindly request you to help me on this.