Calculation help

[Anonymous]

i have two tables T1 and T2 as shown below.   I want to calculate number of messgaeid's  sent and received seperately. The report will have a slicer for  'Userid',  and 'date'.

For example....So when i select   'userid' = 1 and  'date'  = 5/1/2019.  i need to show two visuals

 sender(userid)           count of messaged                                   receiver(userid)     count of messageid

 1                                              2                                                        1                                   0

T1

userid

1

2

3

4

5

T2

date	sender(userid)	receiver(userid)	messageid
5/1/2019	1	3	2j2i
5/1/2019	1	4	uiiiu
5/2/2019	1	2	hkj
5/2/2019	2	3	fdf
5/2/2019	3	1	fffgggf
5/2/2019	4	2	dfdf
5/3/2019	5	3	fdfdf
5/3/2019	5	2	ddff
5/4/2019	4	5	dfdf
5/4/2019	1	3	dfdf
5/5/2019	3	2	dddg
5/5/2019	2	5	jijlk

[JIGAR]

@Anonymous 

Please see this pbix for the solution. 

https://drive.google.com/open?id=1aRkM0ENAJaFcVIO2dBfeSBnsoIJsgej_

Hope this helps!!

[Anonymous]

@JIGAR  it is working..but if iwant to show all users in bar chart...with count of messages,, ..how can i do that?

if i select multiple users its not working

[ChandeepChhabra]

@Anonymous 

Create a simple measure

count of messaged = COUNTA(YourTableName[count of messaged])

And drag this visual into your table

[Anonymous]

i need to have only one slicer for userid and date..and that should filter both   sending and receiving messages for userid...

slicer1 = 'userid'   slicer2 = 'date'

userid on y axis   and  count of messgaes (received)

userid on y axis   and  count of messgaes (sent)

[JIGAR · Accepted solution]

@Anonymous 

1 single slicer for userid filter data for both (Receiver and Sender). Have a look at this updated pbix.

This allows multiple userid selection. 

https://drive.google.com/open?id=1aRkM0ENAJaFcVIO2dBfeSBnsoIJsgej_

Hope this helps !!

[Anonymous]

@JIGAR  awesome..its working. thanks a lot...one question...i dont see any relationship between tables..and it is working fine. ..dont we need any relationship?

[JIGAR]

@Anonymous 

Not really in this scenario.

But you might need a relationship between tables for a different scenario.