Forum Discussion

jerryr125's avatar
jerryr125
Helper IV
1 year ago
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...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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

jerryr125's avatar
jerryr125
Helper IV
1 year ago

Perfect !!! Thank you very much !