Forum Discussion

nti-cristiano's avatar
nti-cristiano
Frequent Visitor
7 years ago
Solved

Filter table and show its VALUES

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(dTi...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    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's avatar
nti-cristiano
Frequent Visitor
7 years ago

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's avatar
MFelix
Super User
7 years ago

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's avatar
    nti-cristiano
    Frequent Visitor
    7 years ago

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