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

jerryr125's avatar
jerryr125
Helper 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

  • jerryr125's avatar
    jerryr125
    Helper IV
    1 year ago

    Hi - Anonymous 

    Thank you again for your help.

    Ok, here is what I am trying to do.

     

    Data table:

    tbl_abc

     

    StoreDescOrderIDOpen Orders
    StoreA12Y
    StoreA34Y
    StoreA56N
    StoreB78Y
    StoreB90Y
    StoreCABY
    StoreDCDY
    StoreEEFY
    StoreEGHN

     

    measure:

    kpi-store-name = 

    var a = SUMMARIZE(filter('tbl_abc,[OpenOrders] in {"Y"}),[StoreDesc],"ct",COUNTROWS('tbl_abc'))
    return CONCATENATEX(TOPN(1,a,[ct]),[StoreDesc])
     
    kpi-store-name results in StoreA, StoreB since both stores have two open orders (the "N" are not included
     
    PAGE: HOME
    measure:
    kpi-display-card = 
    tbl_abc[kpi-store-name] & "has the most open orders"
     
    Displays:
    StoreA, StoreB has the most open orders
     
    The kpi-display card measure appears in a card visualization on the home page.
     
    I added an invisible box on the homepage. When the end-user clicks on the card I would like them to go to a page "store-open-orders".  The "store-open-orders" page displays a table visualization.  The table visualization has the following:
     

     

    PAGE: store-open-orders

    table visualization:

     

    StoreDescOrderIDOpen Orders
    StoreA12Y
    StoreA34Y
    StoreB78Y
    StoreB90Y

     

    So I basically would like to connect the visible button from the home page to the store-open-orders page.  The store-open-orders page would filter on the values in the measure "kpi-store-name".'

     

    I think we are close - just need to connect and filter - Jerry