Summarizecolumns table and dCalendar/Date table

[nti-cristiano]

Hi guys,

Pls, help me! What am I doing wrong? When I filter just dTicket[Status]<>"CLOSED" I have a table with the result but when I add the other CONDITION which is dTicket[Created_Date]<MIN(dCalendar[Date] I don't have any return in my table. P.S: This same FILTER works fine in a MEASURE that I have.

Backlog opened yet table = SUMMARIZECOLUMNS(

    fTicketOwner[Division_Verification_Picklist];

    dCalendar[date];

    dTicket[Created_Date];

    dTicket[Incident_Number];

    dTicket[Status];

    FILTER(dTicket;AND (dTicket[Status]<>"CLOSED"; dTicket[Created_Date]<MIN(dCalendar[Date])));

    "Total of Tickets"; COUNTROWS(dTicket)

)

This MEASURE with the same FILTER returns the result normally:

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

[v-juanli-msft · Accepted solution]

Hi @nti-cristiano 

Try this formula to create a new table

Backlog opened yet table =
ADDCOLUMNS (
    FILTER (
        SUMMARIZECOLUMNS ( fTicketOwner[Division_Verification_Picklist],
        dCalendar[date],
        dTicket[Created_Date],
        dTicket[Incident_Number],
        dTicket[Status] ),
        AND (
            dTicket[Status] <> "CLOSED",
            dTicket[Created_Date] < MIN ( dCalendar[Date] )
        )
    ),
    "Total of Tickets", COUNTROWS ( dTicket )
)

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@nti-cristiano any reason why you want summarize table?

[nti-cristiano]

@parry2k 

Yes, in my measure I just get the COUNTROWS (quantity of tickets of the filter), I want to create a table (using the same filter of my measure) with the data like: Incident_Number, Subject etc.

This measure that I'm refering above is:

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