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

MFelix's avatar
MFelix
Super User
7 years ago

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'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!!!!