Forum Discussion

jerryr125's avatar
jerryr125
Icon for Helper IV rankHelper 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

jerryr125's avatar
jerryr125
Icon for Helper IV rankHelper IV
1 year ago

Hi - I think we are getting very close.

All of the measure work.

 

kpi-store-name = 

var a = SUMMARIZE(filter('tbl_abc,[OpenOrders] in {"Y"}),[StoreDesc],"ct",COUNTROWS('tbl_abc'))
return CONCATENATEX(TOPN(1,a,[ct]),[StoreDesc])
 
FilteredOrders =
CALCULATE(
COUNTROWS('tbl_abc'),
FILTER('tbl_abc', 'tbl_abc'[StoreDesc] = [SelectedStoreName])
)
 
SelectedStoreName = SELECTEDVALUE('tbl_abc'[StoreDesc])

 

I have a button that goes from the home to the OpenOrders page.

What is the action do I need to set for the OpenOrders Page ? 

Do I need to set a Drillthrough or Filter on the OpenOrders Page?

THere is no slicer/sync slicer for these measures.

 

Thoughts ? Jerry

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi jerryr125,

 

Could you please share a few screenshots of your setup—particularly the button settings, the OpenOrders page, and any relevant filters or visuals? Kindly blur or mask any secured or sensitive data fields. This will help me better understand your scenario and provide a more accurate resolution. Additionally, a clear explanation of your requirements, along with any expected output, would be greatly appreciated to ensure an accurate and efficient response.

 

Thanks & Regards,

Prasanna kumar