Forum Discussion
Create button to copy selected rows from visual table into a new table?
Hi there,
I have a list of Notifications, I want to be able to send this to users who can select values fon the visual dashbaord and click a button that will then take those selecteed rows and add them to a different table. I have been trying for a while and am struggling to find a way to refer to the selected values from my visual table in DAX. Has anyone got any suggestions for how to do this?
This is my attempt so far:
ChosenRows =
CALCULATETABLE(
SUMMARIZE(
'SAPDataSnowflake',
'SAPDataSnowflake'[NOTIFICATION_ID],
'SAPDataSnowflake'[NOTIFICATION_DESCRIPTION],
'SAPDataSnowflake'[FUNCTIONALLOCATION_ID]
),
'SAPDataSnowflake'[NOTIFICATION_ID] IN SELECTEDVALUE('HomePageNotifications'[NOTIFICATION_ID'])
)My visual table is named "HomePageNotifications" on the selections pane but when i try this it says "Cannot find table
11 Replies
- lbendlin
Super User
and click a button that will then take those selecteed rows and add them to a different tableSounds like an unnecessary step when your data is already filtered by the user choice? Can they use the export menu option on the filtered visual?
The dashboard is being sent out to multiple different departments, each department will then be able to select which notifications they deem to be our highest priority and then, once selected, click the button to add it to the secondary table which will collect the highest priorities from each department and also display a count for eachnotification for how how many different users designated it high priority
Is this something that is possible?
