Forum Discussion
Solved
Create Button to send a specific field-value to a sheet
Hi - I am looking to do the following: * Create a button that will send the user to another sheet with details. the measure is called "kpi-store-name" Note: the measure for the "kpi-store...
Hi jerryr125,
Thanks for giving detailed information on the requirement.I have created a calculated table using DAX as shown below:
TopOpenStores =
VAR a =
SUMMARIZE(
FILTER('tbl_abc', 'tbl_abc'[Open Orders] = "Y"),
[StoreDesc],
"ct", COUNTROWS('tbl_abc')
)
VAR maxCt = MAXX(a, [ct])
RETURN
FILTER(a, [ct] = maxCt)
On the Details Page, I have placed two columns for visualization.
On the Main Page, a button has been added and configured to navigate to the Details Page.I have reproduced the scenario as per the requirement and attached the .pbix file for your reference.
If the issue still persists, please feel free to reach out — we’re here to help.
Thank you & Regards,
Prasanna Kumar
