Forum Discussion

bhmiller89's avatar
bhmiller89
Icon for Helper V rankHelper V
9 years ago

Help with COUNT

I'm trying to determine how many opportunities had a "same day turnaround."    I have a calculated column called "Days in queue" which is a datediff.    Then I wrote a measure: #SameDayTurn = CAL...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi bhmiller89,

 

According to your description, you have created a measure to count how many opportunities had a same day turnaround, and place this measure to a table visual. You only want to display Opportunities with "DaysinQueue = 0" in a table visual, right?

 

In your scenario, you can place the field [OpportunityID], [DaysInQueue] and the measure to the table visual, then add a visual level filter to filter table data. See:

 

1. Sample data:

 

 

2. Before add filter:

 

 

3. After add Visual level filter:

 

 

 

Best Regards,
Qiuyun Yu