Forum Discussion

Imagauthamam's avatar
Imagauthamam
Icon for Helper III rankHelper III
2 years ago
Solved

Get the user input stored in a parameter

I have a requirement where I have to give a search bar like visual and the end user will give an value. The value entered by the user should be captured and it should be used to filter the visual. I...
Need Help
Show and Tell
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, Imagauthamam 

     

    You can try the following methods.
    Slicer table:

    Measure:

    Search = SEARCH(SELECTEDVALUE('Slicer table'[Slicer]),Max('Table'[Description]),1,BLANK())
    Count = 
Var _table=SUMMARIZE('Table','Table'[Date],'Table'[Ticket Number],"Count",[Search])
Return
COUNTX(_table,[Count])+0

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Imagauthamam's avatar
Imagauthamam
Icon for Helper III rankHelper III
2 years ago

jtspilker 

Thanks for the response. But my requirement is different. Let's say I have a ticketing data. It has columns like ticket number, date and description.

 

The above attached image is the input data. Let's suppose the user enters "Access" in the prompt it should group the data by day level and give the count of how many times that word is present in description column.

 

 

 

jtspilker's avatar
jtspilker
Icon for Helper I rankHelper I
2 years ago

ah interesting. one idea: is there anyway you can add a column to the underlying ticketing data that basically is an "Issue Type" that assigns a high level category to each ticket (like Access, Login, Password, etc). you can then have a COUNTROWS measure on your ticketing data table, with a slicer that allows users to select which issue type they want to see.