Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
nti-cristiano
Frequent Visitor

Summarizecolumns table and dCalendar/Date table

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]))))
1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

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.

View solution in original post

3 REPLIES 3
v-juanli-msft
Community Support
Community Support

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
Super User
Super User

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

@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]))))

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.