How do I show records that were counted by Measure

[RandimUser]

I have a table of requests

Sample Table Data

Request ID	Request Name	Status	Request Approval Date	Start Date	End Date	Release Date
21082516390968	Ref ID Change For Sales Compensation Plans	Cancelled	9/10/2021	9/10/2021	9/10/2021	null
21071208572930	Collect EE Vaccination Status In Washington State	Cancelled	7/23/2021	7/30/2021	9/9/2021	null
21070911353602	Streamline International Transfers Wd Process	Cancelled	7/21/2021	7/21/2021	9/8/2021	null
21061713094926	Awaiting Acceptance & Survey Notification Alignment	Cancelled	6/25/2021	6/25/2021	7/29/2021	null
21051313364235	Inclusion Training Announcement Widget	Cancelled	5/21/2021	10/1/2021	10/8/2021	11/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

[RandimUser]

Thank you.

[VahidDM · Accepted solution]

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!!