Need help for Power BI filter condition

Anastasiia K 0 Reputation points
2023-03-30T14:53:24.8+00:00

Hello Power BI masters!

Could I kindly ask you to give some advise how to set up right filtering?

I have a table that contains of several columns.
Example:

Ticket Number Grade Description
12345 A Apple
54321 A Orange
54321 B Banana
54321 C Peach
54321 C Pear

Sum result shows 5

Briefly, there are 3 columns as an example: Ticket Number, Grade, Description.
Grade shows whether is a master ticket (Grade is always A for them) or a subticket (Grade is never A).

If ticket has no subticket - I need to count it as 1 item. Example ticket is 12345.
If ticket has a subticket like ticket 54321 (subticket's Grade is never A) - I need to count only the number of subticket items. In other words, - to ignore parent ticket as an item for such case.
And then to understand the sum of items.

Using a Widget "Card" where I put the column "Ticket number", not summarizing - I got 5 items like a sum. But I need to count them like 4 tickets...

Do you know how I can filter it in this way?

Thanks a lot in advance!

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
3,754 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dave Patrick 426.1K Reputation points MVP
    2023-03-30T15:04:10.7366667+00:00

    The product group for Power Bi actively monitors questions over at https://community.powerbi.com/

    --please don't forget to upvote and Accept as answer if the reply is helpful--