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,

 

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