I'm trying to make a suggestion for the visual table, but I can not figure out how to write the measure for that. When the user can hover over any date (September 28th 2015 ) her Date column, for example, in 11111 Account. The tooltip could show the subtotal (sum of the correspondent Accounted Quantity column) for 11111 Account for the date (28 September 2015). And so on. Similarly, hovering over the type entries (eg payment) will show the sum of all payment types for account 11111. Please, tell me how to do it.
I attach the .pbix file please help.