Forum Discussion
calculate difference between two separate filtered measure
Hi,
Thank you very much for taking your time to help me with this, I really appreciate it.
This helps me with a part of my issue, however I'm afraid it's not exactly what I was looking for.
- the first two tables should show the count of bookingId. This will be an easy fix, however wanted to mention it in case it will affect the next steps :
- in table1 Belgium should show 2, UK 2, France 1 and Italy 1
- in table 2 Italy 1, Belgium 1
- I'm not sure if this is correct, but BookingsTable1 and BookingsTable2, both measures might need a different approach as I'm trying to have this fully dynamic. I'm not sure if this will work if I'm selecting for Table1, only customerB, or customer C and D. The "user" will select what Customer he wants to see in table1 and table2 (therefore, the filters). I've tried to play with your PBI example and Table3(the difference table) didn't show the right countries.
I've selected only customer B (table1) and customer D (table2) and it was supposed to display Belgium, France, UK and Italy. Italy was not showing. ( it should show all countries, just once, no matter if it's in both tables or only in one). It looks likeSee screenshot below:
- this leads me to the next thing. The difference table. This should show the booking difference between table1 and table2. As per the above screenshot, it should show:
- Belgium 0 (table 1 has 1 booking for Belgium minus table2 which has 1 booking as well)
- France 100 (France is not in table2, therefore 100)
- UK 100 (Again, UK not in table2, therefore 100)
- Italy -100 (this should show as minus 100 as Italy is only in table2, so the calculation would be 0 minus 100)
Hope this makes more sense and thank you very much once again for your help
Anonymous - any idea about how can I do the above?
Any help is highly appreciated. Thank you!