Forum Discussion
Filtering directly on a count measure
Hi Anonymous ,
I can understand what you want, but I don't understand the logic of returning the results.
When the slicer selects 'ALL', why does Table 2 return 9 instead of 12?
Why does the slicer select 'Difference', the result of Table 1 is 9 and the result of Table 2 is 6?
Please tell me your counting logic in detail.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I would be basing the Customer Code count on the Venue Code, so there are two venues which is Laguna and Bahamas. Laguna has 9 customer code count in table1 while it only has 6 customer code count in table2 (3 rows that are not matching), that is why if I select "Difference" only the customer code count of each Laguna from their respective tables will be counted since the Laguna from the two tables have differences, that is why the card visual for table1 should show 9 while the card visual for table2 should show 6. Meanwhile Bahamas in table1 has 3 customer code count and likewise the same in table2 (all 3 rows are matching), that is why it is the only thing that will be chosen when selecting "Common"