need help

[Anonymous]

i select the following ticket:  gv0011499907 and i get the following table:

Note: all fields belong to the same table

Ticket                    Company        Activity           Days in Activity

gv0011499907                 22        Operation                         150

gv0011499907                 22        Entry                                     2

gv0011499907                 22         blocked                                0

gv0011499907                 22         sorting                                 0

I have another table like the first but only with the fields:

Ticket    Activity

when i click on the first line of the first table the result in the second table is:

Ticket                     Activity

gv0011499907       Operation

How can i do (in dax) to get as a result in the second table all the rows of the first table, that is to say that the activity filter that is activated when i select the first row of the first table is ignored.

[Anonymous · Accepted solution]

Hi @Anonymous ,

I have an idea for you to try.

Create a table only include ticket column.

Table 2 = SUMMARIZE('Table','Table'[Ticket])

Then create a measure.

Measure = IF(SELECTEDVALUE('Table 2'[Ticket])=MAX('Table'[Ticket]),1,BLANK())

Finally filter the measure is 1.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

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

[Anonymous]

Thank you for Help