cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RandimUser
New Member

How do I show records that were counted by Measure

I have a table of requests

 

Sample Table Data

Request IDRequest NameStatusRequest Approval DateStart DateEnd DateRelease Date
21082516390968Ref ID Change For Sales Compensation PlansCancelled9/10/20219/10/20219/10/2021null
21071208572930Collect EE Vaccination Status In Washington StateCancelled7/23/20217/30/20219/9/2021null
21070911353602Streamline International Transfers Wd ProcessCancelled7/21/20217/21/20219/8/2021null
21061713094926Awaiting Acceptance & Survey Notification AlignmentCancelled6/25/20216/25/20217/29/2021null
21051313364235Inclusion Training Announcement WidgetCancelled5/21/202110/1/202110/8/202111/30/2021

 

I have a measure that counts how many are cancelled and returns a total of records that meet the criteria

 

_Cancelled Requests =
CALCULATE(
COUNT('WD Project Link'[Request ID]),
'WD Project Link'[Status] = "Cancelled",
USERELATIONSHIP('WD Project Link'[End Date], 'Date'[Date])
)
 
How do I create a visual that shows the records that were counted?
 
Thank you
1 ACCEPTED SOLUTION
VahidDM
Community Champion
Community Champion

Hi @RandimUser 

 

If I understood correctly, you want to have a chart that shows only Cancelled and included in the _Cancelled Requests measure.

You can use the desired visual, then add that measure to the filter section and filter to not show the blank.

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

 

View solution in original post

2 REPLIES 2
RandimUser
New Member

Thank you.

VahidDM
Community Champion
Community Champion

Hi @RandimUser 

 

If I understood correctly, you want to have a chart that shows only Cancelled and included in the _Cancelled Requests measure.

You can use the desired visual, then add that measure to the filter section and filter to not show the blank.

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.