This is setup:
1) One list visual showing columns: Category, Total Amount (so list visual, not slicer visual)
2) Second list visual showing Category, Subcategory, Product and some additional fields used for detailed export
As the second visual contains a lot of information, it is very slow.
My goal is that only if user clicks on field Category on the first (list) visual, it shows data on the second visual for that selected category.
There is approach:
Advertiser Is Selected = IF(ISFILTERED(Category[Category Name]),1,0)
But it fails because i also show field category name in the second visual and it returns 1 for each row which means it shows all data.
There are alternatives:
1) to remove category column from that second visual (which is not ideal as it is needed in export)
2) to create drill through button to new page with all these details (which is not ideal as i would need only this specific visual on new page. But for now this seems like the best option)
3) to create tooltip (which is not ideal as user can't export data from tooltip)
But i wondered if using Dax i can work this out?
Thanks in advance
