cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

summary table with continuous count of status duplicates

Hi ALL, 

 

I have a quotelog table that shows different status for each quote. Sometimes this status can be repeated for each quote. in tbe below image i filtered just one "quote" to demonstrate this. I want to be able to see for each "quote" if it had more than 1 count of a status. Im not sure how this would be designed. column or a measure. but simply put in the below image i want a summary that says

 

Quote              Number of times status 2 occured      Number of times status 6 occured 

84848                                          2                                                               2                                

 

The key thing is that i need this to be unaffected by my date filter in the report. its also imporant that i know which status each count is for. 

 

Capture.PNG

2 REPLIES 2
Highlighted
Super User IV
Super User IV

@Melmehal use matrix visual,

 

- Add quote on rows

- Add status on columns

- Add Id on values and change aggregation to Count






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.





Highlighted

That works, however i need to use this as a filter. Here is what each status number means: 

Capture.PNG

I want to be able to on a daily basis track the numbers of quotes where it had status 7 (broker gets estimate). but the issue i run into is that this status 7 can appear multiple times and i only want it to count once ( the first time in which it occured). You might suggest that i should remove my duplicate statuses for each quote and only keep the first instance. This isnt the best solution because if you notice in my initial post, status 2 ( assigned to broker) also occured twice, if i were to only keep the first instance, it would be assigned to the wrong person. 

 

The main question becomes: How can i keep the duplicate statuses of each quote and still be able to count for each quote a distinct count of each status. 

 

so on any given day i want to filter my report and count for each broker how many quotes went through "status 7" on that given day. Say, today a broker took a quote to status 7 ( i only want to count this status once for each quote) BUT he took the same quote to "status 7" 5 days ago, then i dont want it to count for today, because it would have been counted 5 days ago and is now simply a duplicate

 

perhaps what i need is a version of this table which shows only the last instance of each quote's status (which i have already done) and use the main table that has the duplicate statuses as a filter where the count of each status occurence for each quote is NOT greater than 1 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors