Filter table and show its VALUES

[nti-cristiano]

Hi everyone,

Using a Calendar table how can I filter another table (dTicket) based on the selection (in the Calendar) that I do in the visual?

I'd like to use this filter:

FILTER(ALL(dTicket); dTicket[Created_Date]<MIN(dCalendar[Date]))

This a sample of my dTicket table(there is a relationship with Calendar using Created_Date column):

dTicket

How can I filter this dTicket table and get a new table with its data/values filtered already?

[MFelix]

Hi @nti-cristiano ,

To what I can understand you want to create a new table that get all the values that are under the Calendar date selected?

Do you want to have it dinamically based on a selection of a slicer or static based on the minimum value of the calendar table?

If both table are related using the expression you created on your measures as a filter should return values based on that.

Can you please explain a little bit better the context and final result you want to achieve?

Regards,

MFelix

[nti-cristiano]

Hi @MFelix ,

Yes, you're right! I need a table which brings the results based on the FILTER and the selection in the Calendar. What I need is filter the open tickets that are older than the month selected in the Calendar, in other words, I need the tickets in backlog related to the month that I select in the visual.

I have one measure using the same filter (that I've specified above) but this measure brings just the COUNT of ROWS(the quantity of tickets) and now I need to bring the data of the tickets (subject, number, date of creation etc).

[MFelix]

Hi @nti-cristiano ,

If you already have a measure that makes the rouw count you can use it to filter out a table visual with the information you need, the only thing that you need to make sure is that the Calendar data column is included in your visual and put your Count of rows in the filter.

Regards,

MFelix

[nti-cristiano]

@MFelix 

Thanks for the help!! My problem is exacly that, how can I mount a table instead of count rows? I've been trying using SUMMARIZE, SUMMARIZECOLUMN, CALCULATETABLE and even ADDCOLUMN, but I don't know how to create a table from the result from a FILTER. Please, help me to transform my measure that counts rows into create a table with the data, this is my current measure:d

Backlog opened yet = CALCULATE(COUNTROWS(dTicket);FILTER(ALL(dTicket);AND (dTicket[Status]<>"CLOSED"; dTicket[Created_Date]<MIN(dCalendar[Date]))))

[MFelix · Accepted solution]

Hi  @nti-cristiano ,

Don't create a table, make a table visual with the information you need and place the countrows formula in the fliter of that table or visual, no need to create a new table on your model.

Regards,

MFelix

[nti-cristiano]

Wow!!! That was so much easier than I thought!!! Many thanks @MFelix  it worked perfectly!!!!