Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
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.
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.
@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.
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]))))
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |