Forum Discussion
Calculation help
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 |
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 !!
7 Replies
Anonymous
Create a simple measure
count of messaged = COUNTA(YourTableName[count of messaged])And drag this visual into your table
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
Please see this pbix for the solution.
https://drive.google.com/open?id=1aRkM0ENAJaFcVIO2dBfeSBnsoIJsgej_
Hope this helps!!
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
